Two XLStart Directories

  • Thread starter Thread starter GB
  • Start date Start date
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.
 
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
 
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.
 
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
Click to expand...

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 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
 
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.
Click to expand...
OK thanks. I'll take your, Ron's, and Jim's advice.
 
Back
Top