Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Loading Error
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Loading Error
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." wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Loading Error
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." wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Loading Error
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." wrote in message ... 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." wrote in message ... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Loading Error
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Error in loading DLL | Excel Programming | |||
Error Loading DLL | Excel Discussion (Misc queries) | |||
Error in loading DLL | Excel Programming | |||
Error Loading Add-In | Excel Programming |