Two XLStart Directories

G

GB

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

Ron de Bruin

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
 
J

Jim Rech

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

GB

Ron de Bruin said:
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?
 
G

Gord Dibben

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
 
G

GB

Gord Dibben said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top