Excel Add-In RegisterXLL

Expand Post »

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.

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)

Similar Threads

Ouput in exel in VB.NET
VB - How to open an Excel Doc w/ existing data & add data in specific cells? in VB.NET
Problem formating VB string for clipboard in Visual Basic 4 / 5 / 6
How to write files to an Excel application in Visual Basic 4 / 5 / 6

bud594

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2006

Permalink

Dec 30th, 2006

Re: Excel Add-In RegisterXLL

Where does the variable xll come from?

vegaseat

Moderator

Reputation Points: 1333

Solved Threads: 1403

DaniWeb's Hypocrite

Offline

5,792 posts
since Oct 2004

Permalink

Dec 30th, 2006

Re: Excel Add-In RegisterXLL

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.

Click to Expand / Collapse Quote originally posted by vegaseat ...

Where does the variable xll come from?

bud594

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Python Forum Timeline: list in another list

Next Thread in Python Forum Timeline: Newbie Help

DaniWeb Message

Cancel Changes

User Name
Password