Testing for an addin?

D

Don Wiss

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>.
 
V

Vasant Nanavati

?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.
 
Top