Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Ins check
This may be a stupid question, but is there a way to get the current users
list of Add ins? Add ins are apparently regulated at my workplace and only certain people may have the analysis ToolPak available. I would like to have something to check to see if it's there and if not, close the workbook with a message. I may also need to find out if the user has Solver too. I always thought these came standard, but guess our IT dept may be a little paranoid. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Ins check
Try something like
Sub ListAddIns() Dim AI As AddIn Debug.Print "*********** ALL ADDINS *************" For Each AI In Application.AddIns Debug.Print AI.Name, AI.FullName, AI.Installed Next AI Debug.Print "*********** INSTALLED ADDINS *************" For Each AI In Application.AddIns If AI.Installed = True Then Debug.Print AI.Name, AI.FullName End If Next AI End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Rominall" wrote in message ... This may be a stupid question, but is there a way to get the current users list of Add ins? Add ins are apparently regulated at my workplace and only certain people may have the analysis ToolPak available. I would like to have something to check to see if it's there and if not, close the workbook with a message. I may also need to find out if the user has Solver too. I always thought these came standard, but guess our IT dept may be a little paranoid. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Ins check
That's great. Thanks!!
"Chip Pearson" wrote: Try something like Sub ListAddIns() Dim AI As AddIn Debug.Print "*********** ALL ADDINS *************" For Each AI In Application.AddIns Debug.Print AI.Name, AI.FullName, AI.Installed Next AI Debug.Print "*********** INSTALLED ADDINS *************" For Each AI In Application.AddIns If AI.Installed = True Then Debug.Print AI.Name, AI.FullName End If Next AI End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Rominall" wrote in message ... This may be a stupid question, but is there a way to get the current users list of Add ins? Add ins are apparently regulated at my workplace and only certain people may have the analysis ToolPak available. I would like to have something to check to see if it's there and if not, close the workbook with a message. I may also need to find out if the user has Solver too. I always thought these came standard, but guess our IT dept may be a little paranoid. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a check form, and then have info go to a check register | Excel Worksheet Functions | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) |