Thread: Verify Custom Add In via vba/macro?

Hi - I'm using Excel 2007 to create an appliation to check mass volumes of data. The tool is working nicely for the most part, but I'd like to make sure the end users have a particular add-in, xyzaddin, running before the first userform is presented.

Is there any way to automate a check for this add in? I'll set it to run on the workbook open and present an option to get it automatically, or get it manually, whichever the user prefers. But, I'd like to start out by doing the check.

Any help is appreciated!

JP

Code:

Private Sub Workbook_Open()
Dim bool_xla As Boolean: bool_xla = AddIns("Name of Your AddIn").Installed
If bool_xla = False Then MsgBox "Install Add-In", vbCritical, "Missing Add-In"
End Sub

You can install the Add-In automatically if you know where it is located.