I did a copy and paste of the code into into a macro as well as to try it as
a declaration on the sheet. Neither worked for me. There was no result at
all. I also removed the Add-Ins I am testing for - again, no result at all...

I also changed the Add-In name to the literal, mixed case text string of
"Analysis ToolPak" and even substitiuted the name that appears in the VB
Editor, which is FUNCRES.XLA, but again - no result.

Have I missed something?

PLEASE NOTE : I would like the result to appear in a cell on the worksheet.
Something like "Analysis ToolPak = NOT INSTALLED" or "Analysis ToolPak =
VALIDATED".

Thanks

"Michael" wrote:

This will ensure the addins is being used.

On Error Resume Next ' turn off error checking
Set wbMyAddin = Workbooks(AddIns("analysis toolpak").Name)
lastError = Err
On Error GoTo 0 ' restore error checking
If lastError < 0 Then
' the add-in workbook isn't currently open. Manually open it.
Set wbMyAddin = Workbooks.Open(AddIns("analysis toolpak").FullName)
End If

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"RayportingMonkey" wrote:

I have created a number of automated reports in Excel and now need to pass
the actual report generation on to a team of Analysts.

I order for these reports to run correctly, the user must have the €œAnalysis
ToolPak€� and the €œAnalysis ToolPak-VBA€� installed on their machine.

Is there a way I can test to see if these are installed without making the
user physically go to ToolsAdd-Ins and looking?

Thanks for your help!