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!