Location of Add-in's

[Guest]

Is there a way to find out where Excel will copy .XLA file to?

e.g mine is:

C:\Documents and Settings\<username>\Application Data\Microsoft\AddIns

Is it possible to get this path from within VB without loading the VBA?

 

[Bob Phillips]

Hi Trefor,

Try

application.userlibrarypath

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

spot on thanks.

--
Trefor

Hi Trefor,

Try

application.userlibrarypath

--

HTH

RP
(remove nothere from the email address if mailing direct)