xlStart in Vista

[timdolezal]

What I need to do is find how I can have a work book open when Excel
starts in Vista.
With XP and before this was done by placing the work book in the
xlStart directory in the users Application Data\Microsoft\Excel
directory. That path is now locked, as far as I can tell.

Office 2003.

 

[Chip Pearson]

I use my own XLStart directory since I have workbooks that I want opened
regardless of which version of Excel I happen to be using. Just create a new
folder called "C:\XLStart" and choose that folder as the "Alternate Startup
Directory" or "Open files in this directory when Excel starts" setting. The
wording of that setting varies between versions of Excel but they all mean
same thing.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Jim Rech]

RE the Vista part, I dabbled with it a bit and had my frustrations trying to
look in C:\Documents and Settings\...

I learned that that path isn't 'real'. It's just there for backward
compatibility or something like that. The real path for user settings is
off of the C:\Users (I think, going from memory).

--
Jim
| What I need to do is find how I can have a work book open when Excel
| starts in Vista.
| With XP and before this was done by placing the work book in the
| xlStart directory in the users Application Data\Microsoft\Excel
| directory. That path is now locked, as far as I can tell.
|
| Office 2003.
|

 

[timdolezal]

Thank you. I had forgotten that that was an option.

 

[alowenst]

If you used c:\Documents and Settings\<user name>\Application Data\Microsoft\Excel\XLStart in XP, try C:\Users\<user name>\AppData\Roaming\Microsoft\Excel\XLStart in Vista.