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.

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.