VB Script Help

[Quanchi]

I need help with a VB script for Excel.

I need a VB script that runs when an Excel file is opened to check t
see if the Analysis ToolPak addin is checked, if not checked to check
if checked, leave it alone.

Any ideas?

Thanks in advance.

Quanch

 

[Chip Pearson]

Quanchi,

Try something like

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



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Quanchi]

Ok.....this works on my computer....but when I send the file to someone
it gives this a VB error.

Any ideas

 

[Chip Pearson]

What error? Is the Analysis ToolPak available on the offending PC?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Quanchi]

The computer that I tried to open the Excel file on does have th
Analysis ToolPak on it.

When the file is opened, I get "Run Time error 1004."

And it says "Unable to set the installed property of the Addin class."

Any ideas?

Thanks,

Quanch