Run Macro from Python
You can use xlwings package to perform different actions in Excel from Python.
Filepath of the macro: wb = Workbook(‘Z:\\MacroVar.xlsm‘)
Name of the Macro to run: Application(wb).xl_app.Run(‘MacroVar‘)
#PYTHON 2.7 from xlwings import Workbook, Application wb = Workbook('Z:\\MacroVar.xlsm') Application(wb).xl_app.Run('MacroVar')
