Get the Name of the Add-In Workbook used as a Reference

  • Thread starter Thread starter RyanH
  • Start date Start date
R

RyanH

I have an Add-in workbook that contains all my procedures to manipulate data
on my "Main" workbook. Is there a way to get the name of the Add-In workbook
that is used as a reference?
 
I'm not sure what you're looking for, but code like

Dim AI As AddIn
Set AI = Application.AddIns("Cell Contents Viewer")
With AI
Debug.Print .Name
Debug.Print .FullName
Debug.Print .Installed
End With


You can use

Set AI = Application.AddIns(N) ' N = integer value
rather than
Set AI = Application.AddIns("Cell Contents Viewer")

Beyond that, I don't really understand your question.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top