Solved: test for Add-Ins, prompt to activate if not

[mperrah]

Hello again all,
I have a form that requires an add-in.
Can I prompt the user to activate an add-in if it is not present on load?
Or just activate with a macro without a prompt?

Thanks in advance

[mdmackillop]

You can add/remove it on opening/closing
Private Sub Workbook_Open()
AddIns("vbax KB Search").Installed = True
End Sub

[mperrah]

Do I just type analysis toolpak in the parenthases? (sp?)

Private Sub Workbook_Open()
AddIns("analysis toolpak").Installed = True
End Sub

Mark

[mperrah]

That was it.
I needed analysis toolpak - vba for the weeknum() formula.
Thank you, yet again.
Mark
:thumb