Addins not loading when opening from code

G

Guest

Hello all,

I have a workbook that uses the "Analysis ToolPak" Addin. When I open the
workbook normally, everything is fine with no probs. If I try to open the
workbook through code though, it acts like the addins are not installed, even
though when you goto Tools > Addins the option is checked.

I have other workbooks with this same setup that opens fine through code,
it's just this one workbook.

Does anyone know what would cause the addins not to be recognized for only
this workbook and no others?

Thanks, Jack
 
B

Bob Phillips

Opening from code does not load the addins, you need to do it yourself from
the code.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
T

Tom Ogilvy

If you open excel through automation, the addins are not loaded. You have
to load them yourself (in your code).

It is unclear if this is what you are doing or why you say other identical
workbooks don't have this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top