| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add-ins don't work
Excel 2002 (v.10.2614) on W2kPro (sp4) does not load add-ins into
memory. Please help. Boba |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Linear Mode
