VB Script Help

  • Thread starter Thread starter Quanchi
  • Start date Start date
Q

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
 
Quanchi,

Try something like

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



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Ok.....this works on my computer....but when I send the file to someone
it gives this a VB error.

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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
 
Back
Top