Python

Python RSS

Excel Add-In RegisterXLL

•

Join Date: Dec 2006

Posts: 2

Reputation: bud594 is an unknown quantity at this point

Solved Threads: 0

bud594

Offline

Newbie Poster

Excel Add-In RegisterXLL

Dec 29th, 2006

I seem to have an intermittent issue with the following code segment. I am installing an application which has an associated excel add in which I register and then run the on open macro. The formula then calls one of the functions from the add-in.

The script fails at the RegisterXLL step, reporting "AttributeError: Excel.Application.RegisterXLL", and then after failing for a number of times it will succeed until I reboot after which time it will commence failing again for a number of iterations following which it will work.

If I run the script and let it fail and then comment out the install step the script works.

This is running on both Win2K and WinXP o/s and both Excel 2000 and 2003. Any ideas gratefully received.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
import os
from win32com.client import Dispatch
os.system (install "setup.exe" in silent mode)
xlApp = Dispatch("Excel.Application")
xlApp.RegisterXLL(xll)
xlApp.Visible = 1
wb=xlApp.Workbooks.Add()
xlApp.Workbooks.Open(xla).RunAutoMacros(1)
xlApp.ActiveSheet.Cells(1,1).Formula = '=xversion()'
wb.Close(SaveChanges=0)
xlApp.Quit()
xlApp.Visible = 0
del xlApp
os.system (uninstall "setup.exe" in silent mode)
import os
from win32com.client import Dispatch
os.system (install "setup.exe" in silent mode)
xlApp = Dispatch("Excel.Application")
xlApp.RegisterXLL(xll)
xlApp.Visible = 1
wb=xlApp.Workbooks.Add()
xlApp.Workbooks.Open(xla).RunAutoMacros(1)
xlApp.ActiveSheet.Cells(1,1).Formula = '=xversion()'
wb.Close(SaveChanges=0)
xlApp.Quit()
xlApp.Visible = 0
del xlApp
os.system (uninstall "setup.exe" in silent mode)

•

Join Date: Oct 2004

Posts: 3,858

Reputation: vegaseat is just really nice

Solved Threads: 867

vegaseat

Offline

DaniWeb's Hypocrite

Re: Excel Add-In RegisterXLL

Dec 30th, 2006

Where does the variable xll come from?

May 'the Google' be with you!

•

Join Date: Dec 2006

Posts: 2

Reputation: bud594 is an unknown quantity at this point

Solved Threads: 0

bud594

Offline

Newbie Poster

Re: Excel Add-In RegisterXLL

Dec 30th, 2006

xll is the full path of the xll file and xla is the full path of the xla file.

I am a little confused though, even with the xlApp.Quit() and del xlApp there is still an excel.exe visible in the taks manager. If this is running before the script starts then it works, if it is not then it fails.

•

Originally Posted by vegaseat