Add-In Loading Error

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

When I issue this command in the workbook_Open() sub:
AddIns("Vip").Installed = True

I get this error:
Run-time Error 9 Subscript out of range

The add-in is NOT in any Add-in path but just "out on the server". But I
have loaded it previously, manually. Ideas?
 
Is it in the addins list but just unchecked, or not even in that list?

Also try setting it to False, and then set it to true.
 
This is driving me nuts. Sometimes it works. Sometimes I get error 1004.
Sometimes it shows up in the add-ins but is unchecked. Sometimes NOTHING
shows up in the add-ins list. Sometimes a whole bunch of add-ins are in the
list. I just don't get it. If it was consistent, I could live with it. I
do NOT want to copy the add-in to a personal directory because then people
could be using an older version. I want the newest one only. If I turn
error off, it auto-attempts to copy. Sometimes the copy fails too. I don't
get it.
 
If it isn't in the addins list, install won't work because that is
installing from the addins collection (the addins list).
 
I just gave up and revamped all my code to eliminate the use of an add-in.
It doesn't seem to want to consistently load. I don't understand why others
have not had problems like this.
 
Back
Top