add-ins don't work
 

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory.
Please help. Boba

add-ins don't work
 

We need a few more details... are you opening things through Code? Code does
not load the addins by default. You have to to that manually...

"Boba" wrote:

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory.
Please help. Boba

add-ins don't work
 

how do you do that?
Thanks
Rob

"Jim Thomlinson" wrote:

We need a few more details... are you opening things through Code? Code does
not load the addins by default. You have to to that manually...

"Boba" wrote:

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory.
Please help. Boba

add-ins don't work
 

assuming you accessing excel thru automation..
opening the "normally installed" addins:

dim xlApp as excel.application
dim ai as excel.addin
for each ai in xlApp.addins
if ai.installed then xlApp.Workbooks.open ai.fullname, addtomru:=false
next



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob wrote :

how do you do that?
Thanks
Rob

"Jim Thomlinson" wrote:

We need a few more details... are you opening things through Code?
Code does not load the addins by default. You have to to that
manually...

"Boba" wrote:

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory.
Please help. Boba

add-ins don't work
 

Thanks for your reply. In my search I also found another reply from Bob
Phillips, which I think would suggest the modification to your code shown
below, which runs the open event of each of the adddins.

dim xlApp as excel.application
dim ai as excel.addin
for each ai in xlApp.addins
if ai.installed then xlApp.Workbooks.open(ai.fullname,
addtomru:=false).RunAutoMacros 1
next



"keepITcool" wrote:


assuming you accessing excel thru automation..
opening the "normally installed" addins:

dim xlApp as excel.application
dim ai as excel.addin
for each ai in xlApp.addins
if ai.installed then xlApp.Workbooks.open ai.fullname, addtomru:=false
next



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob wrote :

how do you do that?
Thanks
Rob

"Jim Thomlinson" wrote:

We need a few more details... are you opening things through Code?
Code does not load the addins by default. You have to to that
manually...

"Boba" wrote:

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory.
Please help. Boba

add-ins don't work
 

yep.
entirely true.
some addins still use AutoMacros.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob wrote :

Thanks for your reply. In my search I also found another reply from
Bob Phillips, which I think would suggest the modification to your
code shown below, which runs the open event of each of the adddins.

dim xlApp as excel.application
dim ai as excel.addin
for each ai in xlApp.addins
if ai.installed then xlApp.Workbooks.open(ai.fullname,
addtomru:=false).RunAutoMacros 1
next



"keepITcool" wrote:


assuming you accessing excel thru automation..
opening the "normally installed" addins:

dim xlApp as excel.application
dim ai as excel.addin
for each ai in xlApp.addins
if ai.installed then xlApp.Workbooks.open ai.fullname,
addtomru:=false next



--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Rob wrote :

how do you do that?
Thanks
Rob

"Jim Thomlinson" wrote:

We need a few more details... are you opening things through
Code? Code does not load the addins by default. You have to to
that manually...

"Boba" wrote:

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins
into memory.
Please help. Boba

add-ins don't work
 

Turn on the macro recorder, load an add-in through the GUI, turn off
the recorder, and switch to the VBE. XL will give you the necessary
code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
how do you do that?
Thanks
Rob

"Jim Thomlinson" wrote:

We need a few more details... are you opening things through Code? Code does
not load the addins by default. You have to to that manually...

"Boba" wrote:

Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory.
Please help. Boba