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.

--
__________________________________
HTH

Bob

"Mike H." <(E-Mail Removed)> wrote in message
news:15D3F412-DD0B-4B99-A391-(E-Mail Removed)...
> 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?
>
>

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" wrote:

> 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.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Mike H." <(E-Mail Removed)> wrote in message
> news:15D3F412-DD0B-4B99-A391-(E-Mail Removed)...
> > 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?
> >
> >
>
>
>

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

--
__________________________________
HTH

Bob

"Mike H." <(E-Mail Removed)> wrote in message
news:E8F670AC-FCA6-4365-B2BD-(E-Mail Removed)...
> 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" wrote:
>
>> 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.
>>
>> --
>> __________________________________
>> HTH
>>
>> Bob
>>
>> "Mike H." <(E-Mail Removed)> wrote in message
>> news:15D3F412-DD0B-4B99-A391-(E-Mail Removed)...
>> > 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?
>> >
>> >
>>
>>
>>

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.