title: Python Running an Excel Macro
body: <p>I am trying to use python to run an excel macro and then close excel. I have the following:</p>
  
  <pre><code> 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
  </code></pre>
  
  <p>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:</p>
  
  <p>Traceback (most recent call last):
    File "C:\Python27\File1.py", line 6, in 
      xl.run("File1.xlsm!WorkingFull")
    File "", 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)</p>
  
  <p>I have macros enabled and I know its in the workbook, what is the problem?</p>