| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
