Add-In Loading Error

[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?

 

[Bob Phillips]

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.

 

[Mike H.]

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.

 

[Bob Phillips]

If it isn't in the addins list, install won't work because that is
installing from the addins collection (the addins list).

 

[Mike H.]

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.