| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Where do excel 2003 add-in's live? | Excel Discussion (Misc queries) | |||
| COM add-in's | Excel Discussion (Misc queries) | |||
| Office 2003 Purchaser can't add in the add in's. Why? | Excel Worksheet Functions | |||
| Protecting Add-In's from viewing | Excel Programming | |||
Hybrid Mode
