Is there a way to check if a particular Add In has been installed in User's
Excel?

I have some xlVeryHidden sheets that should only be made visible if the User
has a particular Add In which interfaces with Oracle.

Thanks for your insight and assistance.

Rick

Rick;

In my view an Add-in is a workbook; a special workbook.
So, if you check for that workbook to be open, your problem should be
solved.

To find VBA code to do this check, do the google.
Lot's of examples for it.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--
"rick" wrote in message
...
Is there a way to check if a particular Add In has been installed in
User's Excel?

I have some xlVeryHidden sheets that should only be made visible if the
User has a particular Add In which interfaces with Oracle.

Thanks for your insight and assistance.

Rick

Rick,

You didn't give the name of your addin so this check if the VBA analysis
toolpak is loaded. Substitute your addin name


Sub isaddinloaded()
On Error Resume Next
Set chkaddin = Workbooks("ATPVBAEN.XLA")
If Err Then MsgBox "ATPVBAEN.XLA! not loaded" & _
vbLf & vbLf & "Can't continue!", vbCritical + vbOKOnly, _
"Addin not loaded": Exit Sub
Err.Clear
On Error GoTo 0
End Sub

Mike
"rick" wrote:

Is there a way to check if a particular Add In has been installed in User's
Excel?

I have some xlVeryHidden sheets that should only be made visible if the User
has a particular Add In which interfaces with Oracle.

Thanks for your insight and assistance.

Rick

Rick,
Try clicking on the marble, then, in the bottom right of the window, you
should see excel options button. Click and you will see the Add-In button on
the left, click to see what add-ins are in use, available or to manage.
hope this helps.
babs



"rick" wrote:

Is there a way to check if a particular Add In has been installed in User's
Excel?

I have some xlVeryHidden sheets that should only be made visible if the User
has a particular Add In which interfaces with Oracle.

Thanks for your insight and assistance.

Rick

Yes you can do this

If bIsBookOpen_RB("MenuAddin.xlam") = False Then .......


It use this function

Function bIsBookOpen_RB(ByRef szBookName As String) As Boolean
' Rob Bovey
On Error Resume Next
bIsBookOpen_RB = Not (Application.Workbooks(szBookName) Is Nothing)
End Function


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Spreadsheet Solutions" wrote in message ...
Rick;

In my view an Add-in is a workbook; a special workbook.
So, if you check for that workbook to be open, your problem should be
solved.

To find VBA code to do this check, do the google.
Lot's of examples for it.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--
"rick" wrote in message
...
Is there a way to check if a particular Add In has been installed in
User's Excel?

I have some xlVeryHidden sheets that should only be made visible if the
User has a particular Add In which interfaces with Oracle.

Thanks for your insight and assistance.

Rick

Thanks Mike for the programmatic solution...I think people forget that's why
we post here and not simply in .excel ;-)
--
Toby Erkson
Excel 2003, WinXP

"Mike H" wrote in message
...
Rick,

You didn't give the name of your addin so this check if the VBA analysis
toolpak is loaded. Substitute your addin name...

Hi,

You are correct and here's an alternative way using your method

Sub sonic()
For Each wb In Application.AddIns
If wb.Name = "ATPVBAEN.XLA" Then GoTo Continue
Next wb
Exit Sub
Continue:
' rest of code here
End Sub

Mike

"Spreadsheet Solutions" wrote:

Rick;

In my view an Add-in is a workbook; a special workbook.
So, if you check for that workbook to be open, your problem should be
solved.

To find VBA code to do this check, do the google.
Lot's of examples for it.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--
"rick" wrote in message
...
Is there a way to check if a particular Add In has been installed in
User's Excel?

I have some xlVeryHidden sheets that should only be made visible if the
User has a particular Add In which interfaces with Oracle.

Thanks for your insight and assistance.

Rick