Installing Addin Causes Serious Error in Excel 2002

R

Red Rider

I created two Excel addins that worked perfectly well in Excel 2000.

Private Sub Workbook_Open()
‘ code for UpdateAddin.xla

‘ unload addin
AddIns("TestAddin").Installed = False

‘ Code that checks and copies newer version
‘ of TestAddin.xla addin if needed

‘ reinstall addin
AddIns("TestAddin").Installed = True

End Sub

The UpdateAddin addin unloads the TestAddin addin and checks to see if
a newer version is present. It copies the newer version (code not
shown) and then reinstalls TestAddin. When I installed these same
addins in Excel 2002 I get the following error:

Excel experienced a serious error the last time UpdateAddin.xls was
opened. Would you like to disable this addin?

I’ve tried different addins, other than TestAddin, and get the same
result. The problem appears to be uninstalling then reinstalling any
addin using the Workbook_Open() procedure. Since many updates are
done to TestAddin I’m trying to keep the upgrades transparent to
users.
Any help would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Installing Addin Causes Serious Error in Excel 2002 1
Trying to read CustomDocumentProperties of an open 2007 AddIn 1
Addin Auto_Open code executes only in debug mode 2
Closing addin through VBA causes code to stop 2
Order of Excel Addin 1
Difficulty in SaveAs an Addin 4
Use AddIn to Open an addtional Excel Workbook 1
addin running in different Excel instances 7

Top