Open Excel (with Add-Ins loaded) from Access

  • Thread starter Thread starter BMunny
  • Start date Start date
B

BMunny

Hi Everyone

I would like to open an Excel file that has an auto_open
macro in it. However, I would like to open Excel with
Add-ins loaded because my Excel file needs those add-
ins. I know that using the CreateObject method will not
load them.

I've read this article
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;108888 but I'm not sure how to use or when to use the
code they supplied.

Any help would be fantastic!
Thanks in advance
 
Are you saying that:
1. you understand how to program a CreateObject call, but you do not
understand the KB article? Or,
2. you do not understand how to program any of it (including the
CreateObject call)?

If 1., the KB article is quite clear, surely. Just use their code in place
of your own code.

If 2., create a new module. Create a public sub GoToIt in that module. Copy
their code into that sub. Change the filenames etc. in their code, to suit
your system. Click Debug:Compile to check that it compiles ok. Type Ctrl-g
to display the debug window. Then type GoToIt and press return to run the
sub & see what happens.

HTH,
TC
 
Back
Top