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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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

"Quanchi" wrote in message
...

I need help with a VB script for Excel.

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

Any ideas?

Thanks in advance.

Quanchi


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

Any ideas

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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" wrote in message
...

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

Any ideas?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com