View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Trefor Trefor is offline
external usenet poster
 
Posts: 201
Default 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