Hi Gord, I have an addin that i need to have run everytime
(automatically) a user opens Excel 2003. The addins reside in a
directory structure off of C: (C:\HYPERION\essbase\bin - I do not
believe that they can be copied to the XLSTART directory as there are
other files in the bin directory). There are an xll & an xla file in
the directory, but it looks like if you manually add only the xll file
in Excel using the AddIn menu item, it loads the addin properly.
However, if I place a shortcut to the xll file in the XLSTART
directory, it doesn't appear to load the addin. If I place a shortcut
to the xll & xla files in the XLSTART directory, it does appear to load
the add in properly, but they do not show up in the addin list & I fear
that they are not really "installed".

I've also tried creating a shortcut using the application switch:
/LS:\HYPERION\essbase\bin\essxleqd.xla and/or
/LS:\HYPERION\essbase\bin\essexcln.xll

I did find the following code on the MS website (
http://support.microsoft.com/default...b;en-us;280290 ) (which
I have edited), but I am pretty ignorant of how to implement it or use
it. I did try using the instructions you've place here, but I must not
be doing something right because I cannot get it to work.

Are you able to assist with this type of problem? thnx!!

Gord Dibben wrote:
You can include a workbook_open code that loads the ATP when the users open the
file......with macros enabled, of course.

Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
End Sub

To insert this, right-click on the Excel Icon at top left of Menubar and select
"View Code".

Copy/paste the code into that module.


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 11:15:01 -0700, IrvingA
wrote:

I have a spreadsheet that requires the 'Analysis ToolPak' add-in to be
enabled. When I send the spreadsheet to other people, they often don't read
the instructions to enable this add-in and they get errors in the
spreadsheet. Even those that realize the cause of the errors sometimes have
to enable and disbale the add-in a few times before things start working. Is
there a way for the add-in to be enabled automatically when the spreadsheet
is opened?