Is it possible in any way to edit an excel sheet through an ASP.net page that contains macro. I have tried to open the Excel sheet and it seems to just hang rather than load the excel. Testing on a page without macros works perfectly fine?
Trying to call a python script on Vba and I am a newb. I tried converting the main script to an exe using py2exe and then calling it from VBA (shell) but the main script calls other scripts therefore it becomes complicated and I messed it up (my exe is not functional). Besides, the the main script is a large file and I do not want to revise it a lot.
I’m trying to run a macro via python but I’m not sure how to get it working…
I’m using a VBA code that calls a python script. I can send a parameter to my python script and reading it using sys.argv[1].
I’ve read the API docs for xlwings, and played around with Workbook and Sheet objects in the interpreter, but I can’t figure out how to call a macro from Python.
I’ve got a macro that I’d like a bunch of existing spreadsheets to use. The only problem is that there are so many spreadsheets that it would be too time consuming to do it by hand!