[python-win32] excel xla runautomacros

2007-04-25 Thread mjohnson
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

[python-win32] Registering a Server COM to make it visible in the reference list

2007-04-25 Thread Neil Benn
Hello, I have made a COM server using python and registered it using win32com.server.register.UseCommandLine(TrackingClient). That all works fine and I can instantiate it using late binding, however I now need to reference that in C# or VBA in excel. The problem I have is that when

Re: [python-win32] excel xla runautomacros

2007-04-25 Thread Tim Roberts
mjohnson wrote: 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)

Re: [python-win32] excel xla runautomacros

2007-04-25 Thread Hussain Jiwani
Following is a snippet of code that I have been using to figure out if an addin in installed. xlApp = win32com.client.dynamic.Dispatch('Excel.Application') xlApp.DisplayAlerts = 0 xlApp.Interactive = 1 if xlApp.Application.Addins.Count = 0: print

Re: [python-win32] excel xla runautomacros

2007-04-25 Thread Tim Roberts
Hussain Jiwani wrote: Following is a snippet of code that I have been using to figure out if an addin in installed. xlApp = win32com.client.dynamic.Dispatch('Excel.Application') xlApp.DisplayAlerts = 0 xlApp.Interactive = 1 if xlApp.Application.Addins.Count =