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')

[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]