2019-11-08
run macro in xlsm using python
stackoverflow
Question

I have a basic requirement.

I have a .csv file and a .xlsm file which has a macro. I need to copy the .csv file's contents to that .xlsm file and run the macro. I need to use Python.

Is there any script possible to accomplish this?

Thanks in advance.

Answer
1

this link should help to open XLSM via python an fill it with data... Python, Excel, and Charts using win32com

this one shows you how to run a macro Python - run Excel macro

run macro in xlsm using python
See more ...