Python Running an Excel Macro
===

I am trying to use python to run an excel macro and then close excel. I have the following:

     import win32com.client
     import os
    
     xl = win32com.client.DispatchEx("Excel.Application")
     wb = xl.workbooks.open("X:\Location\Location2\File1.xlsm")
     xl.run("File1.xlsm!WorkingFull")
     xl.Visible = True
     wb.Close(SaveChanges=1)
     xl.Quit

My script will Open and close fine if I take out the xl.run("File1.xlsm!WorkingFull")
When I run this I get the following error:

  Traceback (most recent call last):
  File "C:\Python27\RebateP.py", line 6, in <module>
    xl.run("File1.xlsm!WorkingFull")
  File "<COMObject Excel.Application>", line 2, in run
  com_error: (-2147352567, 'Exception occurred.', (0, u'Microsoft Excel', u"Cannot run   the   macro 'File1.xlsm!WorkingFull'. The macro may not be available in this workbook or all macros may be disabled.", u'xlmain11.chm', 0, -2146827284), None)

I have macros enabled and I know its in the workbook, what is the problem?

