Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
I created a workbook that requires the Analysis ToolPak and Analysis
ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
Try to enter an ATP function into a free cell and see if it errs or not.
HTH. Best wishes Harald "Horatio J. Bilge, Jr." wrote in message ... I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
What Harald is suggesting (I think!) is that this can be just as well
handled procedurally, when you send out the workbook, send them instructions on how to check (as Harald suggests) and how to correct. Don't complicate the code unnecessarily. -- __________________________________ HTH Bob "Harald Staff" wrote in message ... Try to enter an ATP function into a free cell and see if it errs or not. HTH. Best wishes Harald "Horatio J. Bilge, Jr." wrote in message ... I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
On Wed, 21 Jan 2009 21:17:02 +0530, Horatio J. Bilge, Jr.
wrote: I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! Hi, Maybe you can modify the code he http://www.cads-sierraleone.org/microsoftexcelltips.htm (Look under "CHECKING IF YOUR ADD-INS ARE ADDED") Hope this helps -- Thanks, Victor Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
On Wed, 21 Jan 2009 21:55:31 +0530, Victor Lobo
wrote: On Wed, 21 Jan 2009 21:17:02 +0530, Horatio J. Bilge, Jr. wrote: I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! Hi, Maybe you can modify the code he http://www.cads-sierraleone.org/microsoftexcelltips.htm (Look under "CHECKING IF YOUR ADD-INS ARE ADDED") Hope this helps On reflection, I agree with what Bob and Haral say. Sending out instructions should be the way to do it. -- Thanks, Victor Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
You could take it out of their hands and enable the add-ins yourself.
Private Sub Workbook_Open() AddIns("Analysis ToolPak").Installed = True AddIns("Analysis ToolPak - VBA").Installed = True End Sub Be sure to change to False on closing the workbook. If you just want a message as you asked use this example code in workbook_open Private Sub Workbook_Open() Set a = AddIns("Analysis ToolPak") If a.Installed = True Then MsgBox "The ATP add-in is installed" Else MsgBox "The ATP add-in is not installed" End If End Sub Gord Dibben MS Excel MVP On Wed, 21 Jan 2009 07:47:02 -0800, Horatio J. Bilge, Jr. wrote: I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
That only works if it was installed when Excel was installed.
-- __________________________________ HTH Bob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You could take it out of their hands and enable the add-ins yourself. Private Sub Workbook_Open() AddIns("Analysis ToolPak").Installed = True AddIns("Analysis ToolPak - VBA").Installed = True End Sub Be sure to change to False on closing the workbook. If you just want a message as you asked use this example code in workbook_open Private Sub Workbook_Open() Set a = AddIns("Analysis ToolPak") If a.Installed = True Then MsgBox "The ATP add-in is installed" Else MsgBox "The ATP add-in is not installed" End If End Sub Gord Dibben MS Excel MVP On Wed, 21 Jan 2009 07:47:02 -0800, Horatio J. Bilge, Jr. wrote: I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
Horatio J. Bilge, Jr. -
You may need to have two sets of VBA code or instructions depending on the version of Excel. The functions provided by the pre-2007 Analysis ToolPak are native worksheet functions in Excel 2007 (therefore not requiring the ATP add-in). - Mike Middleton http://www.MikeMiddleton.com "Horatio J. Bilge, Jr." wrote in message ... I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
I liked the sound of using VBA to enable the ToolPak, but I guess your
suggestion of notification is the best. If a user didn't install the ATP during setup, I would have to go the simple notification route anyway. I just added the appropriate instructions to a "Help" sheet in the workbook. Thanks for the help. ~ Horatio "Bob Phillips" wrote: That only works if it was installed when Excel was installed. -- __________________________________ HTH Bob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You could take it out of their hands and enable the add-ins yourself. Private Sub Workbook_Open() AddIns("Analysis ToolPak").Installed = True AddIns("Analysis ToolPak - VBA").Installed = True End Sub Be sure to change to False on closing the workbook. If you just want a message as you asked use this example code in workbook_open Private Sub Workbook_Open() Set a = AddIns("Analysis ToolPak") If a.Installed = True Then MsgBox "The ATP add-in is installed" Else MsgBox "The ATP add-in is not installed" End If End Sub Gord Dibben MS Excel MVP On Wed, 21 Jan 2009 07:47:02 -0800, Horatio J. Bilge, Jr. wrote: I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
If that is the case, then why do they still have the Analysis ToolPak
available for Excel 2007? I found instructions for loading it in 2007... http://office.microsoft.com/en-us/ex...215691033.aspx Thanks, ~ Horatio "Mike Middleton" wrote: Horatio J. Bilge, Jr. - You may need to have two sets of VBA code or instructions depending on the version of Excel. The functions provided by the pre-2007 Analysis ToolPak are native worksheet functions in Excel 2007 (therefore not requiring the ATP add-in). - Mike Middleton http://www.MikeMiddleton.com "Horatio J. Bilge, Jr." wrote in message ... I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
All those data|data analysis tools (in xl2003 menus) are still part of the
Analysis toolpak. Horatio J. Bilge, Jr. wrote: If that is the case, then why do they still have the Analysis ToolPak available for Excel 2007? I found instructions for loading it in 2007... http://office.microsoft.com/en-us/ex...215691033.aspx Thanks, ~ Horatio "Mike Middleton" wrote: Horatio J. Bilge, Jr. - You may need to have two sets of VBA code or instructions depending on the version of Excel. The functions provided by the pre-2007 Analysis ToolPak are native worksheet functions in Excel 2007 (therefore not requiring the ATP add-in). - Mike Middleton http://www.MikeMiddleton.com "Horatio J. Bilge, Jr." wrote in message ... I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Verify Analysis ToolPak with VBA
I see. Thanks.
"Dave Peterson" wrote: All those data|data analysis tools (in xl2003 menus) are still part of the Analysis toolpak. Horatio J. Bilge, Jr. wrote: If that is the case, then why do they still have the Analysis ToolPak available for Excel 2007? I found instructions for loading it in 2007... http://office.microsoft.com/en-us/ex...215691033.aspx Thanks, ~ Horatio "Mike Middleton" wrote: Horatio J. Bilge, Jr. - You may need to have two sets of VBA code or instructions depending on the version of Excel. The functions provided by the pre-2007 Analysis ToolPak are native worksheet functions in Excel 2007 (therefore not requiring the ATP add-in). - Mike Middleton http://www.MikeMiddleton.com "Horatio J. Bilge, Jr." wrote in message ... I created a workbook that requires the Analysis ToolPak and Analysis ToolPak-VBA add-ins to function. I've discovered that many of the people I gave the workbook to do not have those add-ins enabled, so they get the #NAME? error. Is there a way to automatically check for the Analysis ToolPak? I am thinking that if the ToolPak is not enabled, a message box would pop up telling the user what the problem is, and how to install the ToolPak. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Analysis Toolpak | Excel Discussion (Misc queries) | |||
Analysis toolpak | Excel Discussion (Misc queries) | |||
Analysis ToolPak | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |