Skip to content

Tag: vba

Add custom properties to Excel workbook with openpyxl

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…

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…

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