ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add-ins and Reference library (https://www.excelbanter.com/excel-programming/318335-add-ins-reference-library.html)

Glen Mettler[_4_]

Add-ins and Reference library
 
I need to check if selected add-ins and reference libraries are present when
the user opens the workbook. If they aren't I need to activate them. If
they are not present I need to notify the user.

Is that possible?

Glen



Bob Phillips[_6_]

Add-ins and Reference library
 
Glen,

Here is some code to get you started

Dim addin

For Each addin In Application.AddIns
Debug.Print addin.Name, addin.Installed
addin.Installed = True
Next addin


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Glen Mettler" wrote in message
...
I need to check if selected add-ins and reference libraries are present

when
the user opens the workbook. If they aren't I need to activate them. If
they are not present I need to notify the user.

Is that possible?

Glen






All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com