Location of Add-in's
 

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?

--
Trefor

Location of Add-in's
 

Hi Trefor,

Try

application.userlibrarypath

--

HTH

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


"Trefor" wrote in message
...
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?

--
Trefor

Location of Add-in's
 

spot on thanks.

--
Trefor


"Bob Phillips" wrote:

Hi Trefor,

Try

application.userlibrarypath

--

HTH

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


"Trefor" wrote in message
...
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?

--
Trefor