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

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)


"Jack" wrote in message
...
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

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.

--
Regards,
Tom Ogilvy

"Jack" wrote in message
...
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

Here is some additional information:

http://support.microsoft.com/default...b;en-us;108888
Add-Ins Don't Load When Using CreateObject

http://support.microsoft.com/default...b;en-us;280290
How To Install an Excel Add-In (XLA or XLL) with Automation

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Jack" wrote in message
...
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