Python-сообщество

 import os, os.path
import win32com.client
file = 'excelfile.xlsm'
pathToMacro = 'Module.bas'
myMacroName = 'macros1'
if os.path.exists(file):
    with open (pathToMacro, "r") as myfile:
        macro=myfile.read()
    xl=win32com.client.DispatchEx("Excel.Application")
    wb = xl.Workbooks.Open(os.path.abspath(file), ReadOnly=1)
    xl.Visible = False
    xl.DisplayAlerts = False
    xlModule = wb.VBProject.VBComponents.Add(1)
    xlModule.CodeModule.AddFromString(macro)
    xl.Application.Run(myMacroName)
    xl.SendKeys("{Enter}", Wait=1)
    wb.Close(False)
    xl.Quit()
    del wb
    del xl