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

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?
--
Cheers,
Ryan

Get the Name of the Add-In Workbook 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)


On Fri, 14 Nov 2008 17:52:00 -0800, RyanH
wrote:

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?