| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for an addin?
Hi,
We develop spreadsheets that require the Analysis ToolPak. What code in a Workbook Open event would check for its availability? Don <donwiss at panix.com. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for an addin?
?AddIns("Analysis Toolpak").Installed
True 'False However, "installed" has a non-traditional meaning here; it actually means "activated". If you want to know if it is physically present on the computer and available tro be "installed", you may have to check for the existence of the file FUNCRES.XLA on the hard drive. -- Vasant "Don Wiss" wrote in message ... Hi, We develop spreadsheets that require the Analysis ToolPak. What code in a Workbook Open event would check for its availability? Don <donwiss at panix.com. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Testing | Excel Discussion (Misc queries) | |||
| TESTING | Excel Worksheet Functions | |||
| testing | New Users to Excel | |||
| Testing | Excel Discussion (Misc queries) | |||
| Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Linear Mode
