Two XLStart Directories

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GB - 10 May 2008 13:01 GMT

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.

Reply to this Message

Ron de Bruin - 10 May 2008 13:08 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>I seem to have two XLStart Directories:
>
[quoted text clipped - 5 lines]
> This is a single user machine, by the way, with only one user account
> created on it.

Reply to this Message

GB - 10 May 2008 21:36 GMT

> Hi GB
>
[quoted text clipped - 6 lines]
> 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?

>>I seem to have two XLStart Directories:
>>
[quoted text clipped - 5 lines]
>> the end. This is a single user machine, by the way, with only one user
>> account created on it.

Reply to this Message

Gord Dibben - 11 May 2008 01:16 GMT

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

>> Hi GB
>>
[quoted text clipped - 24 lines]
>>> the end. This is a single user machine, by the way, with only one user
>>> account created on it.

Reply to this Message

GB - 11 May 2008 01:46 GMT

>I would stick with the one under your username.
>
[quoted text clipped - 4 lines]
> 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.

Reply to this Message

Jim Rech - 10 May 2008 19:03 GMT

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.

Signature

Jim

>I seem to have two XLStart Directories:
>
[quoted text clipped - 5 lines]
> the end. This is a single user machine, by the way, with only one user
> account created on it.

Reply to this Message

Rate this thread: