[python-win32] excel xla runautomacros

mjohnson mjohnson at mpjconsultancy.com
Wed Apr 25 16:30:52 CEST 2007


I am having a problem with an excel add-in which is installed via 
xlApp.Workbooks.Open("C:/Program Files/Program/XLOF32.xla").RunAutoMacros(1)

I can then add the add-in and install it via
xlApp.AddIns.Add ("C:/Program Files/Program/XLOF32.xla",True)
xlApp.AddIns.Item(Index='Excel Functions').Installed=True

My problem is that the macro may have already been run, which generates a dialog warning that it is already open.

The question, is there a way of detecting whether the add-in is already open?

Thanks
Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20070425/9aeb4812/attachment.htm 


More information about the Python-win32 mailing list