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.

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




--

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.
>
>
>
>
>
>

The one under Program Files is for "all users" while the other is just for
you. Of course Office has no way of knowing what your intentions are re
having multiple users.

--
Jim
"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.
>
>
>
>
>
>

"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.
>>
>>
>>
>>
>>

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.
>>>
>>>
>>>
>>>
>>>

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:lhec241uno3pob0bu0b1fs9ujahvchqh4k@4ax.com...
>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.
>
OK thanks. I'll take your, Ron's, and Jim's advice.