Install Analysis ToolPak

[Alex]

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.

 

[Chip Pearson]

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)

 

[Gord Dibben]

Alex

In your workbook_open code

AddIns("Analysis ToolPak").Installed = True


Gord Dibben MS Excel MVP