PDA

View Full Version : Solved: Retreive Add-in path



Zack Barresse
08-16-2004, 09:25 AM
Hi,

What is the easiest way to retreive an active add-in path? I can get it for the active workbook, but am having trouble with the proper syntax. I've been playing around with ...

Addins("myname.xla").Path

But I'm not sure how to integrate it, or if that's even right.

mvidas
08-16-2004, 09:32 AM
Hey Zack,

Workbooks("myname.xla").Path

Should work just fine for this!
Matt

Zack Barresse
08-16-2004, 09:38 AM
Doh!

I was under the impression I had to use the Addins Collection Object, well that was easy enough! LOL

Thanks Matt!! Much appreciated! (especially when it's just slapping me in the face :p )

mvidas
08-16-2004, 09:42 AM
Glad to help!