VB Script Help
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 |
VB Script Help
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/ |
VB Script Help
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 |
VB Script Help
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/ |
VB Script Help
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 |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com