Gord
Sat May 10 19:16:08 CDT 2008
I would stick with the one under your username.
Not hard to find if you add a shortcut to it.
Why does having an empty XLSTART folder in Program Files bother you?
I have ignored mine for many years and nothing I run wants any file(s) in there.
Gord Dibben MS Excel MVP
On Sat, 10 May 2008 21:36:24 +0100, "GB" <NOTsomeone@microsoft.com> wrote:
>
>"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
>news:urIXOapsIHA.3804@TK2MSFTNGP02.phx.gbl...
>> Hi GB
>>
>> Use the one with your username in it
>>
>> VBA will give you the correct path
>>
>> 1) Open excel
>> 2) Hit alt-F11 to get to the VBE
>> 3) Hit ctrl-g to see the immediate window and type this:
>> 4) ?Application.StartupPath
>>
>
>That comes back with C:\Documents and Settings\GB\Application
>Data\Microsoft\Excel\XLSTART
>What I think I would like to do is just use one of them and delete the
>other. My preference would be to use the one in Program Files, as that's
>marginally easier to find. Is that going to cause me more trouble than it's
>worth? For example, if I change PCs would the data migration wizard find the
>stuff there or only the stuff under GB?
>
>
>
>
>
>>
>>
>>
>> --
>>
>> Regards Ron de Bruin
>>
http://www.rondebruin.nl/tips.htm
>>
>>
>> "GB" <NOTsomeone@microsoft.com> wrote in message
>> news:48258eab$0$2494$da0feed9@news.zen.co.uk...
>>>I seem to have two XLStart Directories:
>>>
>>> C:\Program Files\Microsoft Office\OFFICE11\XLSTART
>>> C:\Documents and Settings\GB\Application Data\Microsoft\Excel\XLSTART
>>>
>>> Do I need both? I remember having some problems when I added some xla
>>> files to one or other of those, but I can't remember how I resolved it in
>>> the end. This is a single user machine, by the way, with only one user
>>> account created on it.
>>>
>>>
>>>
>>>
>>>