With VBA, I can edit arbitrary workbook metadata like so, and it will be reflected on SharePoint: Now, I am hoping to do the same with openpyxl I can do this for properties without spaces: but properties with spaces won’t work–I try this and the script runs, but nothing shows on SharePoint: This c…
Tag: vba
workbook save failing, not sure why
I apologize for the length of this. I am a relative Neophyte to Excel VBA and even more junior with Python. I have run into an issue with an error that occasionally occurs in python using OpenPyXl (just trying that for the first time). Background: I have a series of python scripts (12) running and querying an…
Running Python in VBA where there are spaces in execution path
I wrote a Python script to perform calculations which I want to run via Excel VBA and display the results in Excel. To be usable for different users I am trying to write a code that will generate the paths to the Python execution and Python scripts based on the usernames they enter since that is the only thin…
xlwings RunPython with function arguments
I am trying to run the RunPython function from a button in excel. I would like the function to take a parameter from a box in excel, something like this: Is this a possibility? And if so how do I write the code? I would prefer not to use UDF. Answer You can do that in two ways: 1) By
Python pandas write resulted dataframe to xlsm without losing the macro
I have a lot of excel files that I need to compile into a single excel file, and then copy the compiled one into an existing excel file (with macro / .xlsm) in a certain sheet. I solved the first problem (compiling multiple excel files into a single excel file). The resulted dataframe is saved in .csv format.…
How to insert a picture into Excel at a specified cell position with python (Anaconda) use vba
I try to use this link with vba code but in Python it doesn’t work. AttributeError Traceback (most recent call last) in () 9 sheet.Cells(20, 20).Select 10 #obj1=sheet.Shapes.AddPicture (r’C:/Users/Home/Desktop/picture.jpg’, False, True, 10, 3, 100, 100) —> 11 obj1=wb.ActiveSheet.Pic…