I don't understand why you are trying to create a shortcut or why you are
wanting to copy any files to your XLSTART folder.

I do know that you have changed the rules in mid-stream.

Your original post asked how to enable the Analysis Toolpak Add-in.

Now you are asking for other add-ins to be loaded.

essxleqd.xla is not a default Excel add-in.

The workbook_open code I posted is inserted into the Thisworkbook module of the
workbook you and users are to open.

Try adding the name of your add-in to the workbook_open code.


Gord

On 10 Aug 2006 13:43:02 -0700, wrote:

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?