I'm wondering if it is possible to get the project name of each registered
addin. I've used the following code to do this for all installed addins but
I'm wondering if this can be done if the addin is not currently installed or
if their is a better way for getting installed addins project names. (using
Xl2000)

For Each ad In Application.AddIns
If ad.Installed And LCase(Right(ad.Name, 3)) = "xla" Then MsgBox
Application.Workbooks(ad.Name).VBProject.Name
Next ad
--
Cheers!

Richard Reye

"Never argue with an idiot. They'll bring you down to their level then beat
you with experience" - someone

The project name is stored inside the project file. You'll need to open a
project in order to read its name. Therefore, if an add-in is not installed
(loaded or opened), you cannot read its name using VBA.

Regards,
Edwin Tam

http://www.vonixx.com


"Richard Reye" wrote:

I'm wondering if it is possible to get the project name of each registered
addin. I've used the following code to do this for all installed addins but
I'm wondering if this can be done if the addin is not currently installed or
if their is a better way for getting installed addins project names. (using
Xl2000)

For Each ad In Application.AddIns
If ad.Installed And LCase(Right(ad.Name, 3)) = "xla" Then MsgBox
Application.Workbooks(ad.Name).VBProject.Name
Next ad
--
Cheers!

Richard Reye

"Never argue with an idiot. They'll bring you down to their level then beat
you with experience" - someone