View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Reye Richard Reye is offline
external usenet poster
 
Posts: 9
Default List all Addin Project Name

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