Several people will be using one Excel file. I need the Analysis ToolPak
installed on everyone's machine and would like to add it to the Workbook_Open
event. Can someone please tell me how to write that code? I've searched and
tried several ways to no avail. Thanks.

The word "install" is ambiguous when it comes to Add-Ins. Does the Analysis
ToolPak (ATP) already exist on the users' machines and all that needs to be
done is load the ATP (which uses a property called "Installed")? Or do you
need to install the ATP add-in file itself on the users' machine and then
load it?

The former is much simpler than the latter.

Sub Auto_Open()
Application.AddIns("Analysis ToolPak").Installed = True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Alex" wrote in message
...
Several people will be using one Excel file. I need the Analysis ToolPak
installed on everyone's machine and would like to add it to the
Workbook_Open
event. Can someone please tell me how to write that code? I've searched
and
tried several ways to no avail. Thanks.

Alex

In your workbook_open code

AddIns("Analysis ToolPak").Installed = True


Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 12:30:01 -0800, Alex wrote:

Several people will be using one Excel file. I need the Analysis ToolPak
installed on everyone's machine and would like to add it to the Workbook_Open
event. Can someone please tell me how to write that code? I've searched and
tried several ways to no avail. Thanks.