add-ins don't work

[Boba]

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

[Jim Thomlinson]

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

[Rob]

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

[keepITcool]

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

[Rob]

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

[keepITcool]

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

[Tushar Mehta]

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 <[email protected]>,
[email protected] 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
> > >
> > >
> > >
>