Where's the Personal.xls in Excel 2003?

[Guest]

I have just upgraded to 2003 and don't know where to put my personal.xls, nor
my .xlb's?

In the 2002 version the personal.xls resided in the C:\Program
Files\Microsoft Office\Office 10\XLStart folder, and

the .xlb's resided in the documents amd settings\name\Application
Dat\Microsoft\Excel

Where do I move my stuff to get it running?

 

[Guest]

In WindowsXP Prof:
C:\Documents and Settings\your user name\Application
Data\Microsoft\Excel\XLSTART

Regards,
Stefi

„Ariel†ezt írta:

 

[Bob Phillips]

Do application.StartupPath in the immediate window in the VB IDE to find it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Dave Peterson]

Just to add...

Excel is pretty smart. If you upgraded over a previous version, you'll find
that excel can still find the previous XLStart folder.

But I'm not that smart. I'd use Bob's suggestion of opening the VBE and hitting
ctrl-g and typing:

?application.startuppath

To find the "latest" location. Then I'd move my personal.xls (and book.xlt and
sheet.xlt and whatever) to this new XLStart location.

For the toolbar, I'd create a new (dummy) toolbar and save it.

Then I'd close excel and use windows|search for *.xlb and move my old toolbar to
that location (wiping out the dummy toolbar).

In some upgrades, it's actually better to rebuild your toolbars from scratch
(icons changed functions--xl95 to xl97 or xl97 to xl2k, IIRC).

It might be worth considering that. You may find that you clean up any garbage
in the XLB file and add/subtract icons from your customized toolbars.

Remember to back up that *.xlb file.

 

[Guest]

Thanks to you all. I have got it up and running!

Just to add...

Excel is pretty smart. If you upgraded over a previous version, you'll find
that excel can still find the previous XLStart folder.

But I'm not that smart. I'd use Bob's suggestion of opening the VBE and hitting
ctrl-g and typing:

?application.startuppath

To find the "latest" location. Then I'd move my personal.xls (and book.xlt and
sheet.xlt and whatever) to this new XLStart location.

For the toolbar, I'd create a new (dummy) toolbar and save it.

Then I'd close excel and use windows|search for *.xlb and move my old toolbar to
that location (wiping out the dummy toolbar).

In some upgrades, it's actually better to rebuild your toolbars from scratch
(icons changed functions--xl95 to xl97 or xl97 to xl2k, IIRC).

It might be worth considering that. You may find that you clean up any garbage
in the XLB file and add/subtract icons from your customized toolbars.

Remember to back up that *.xlb file.

 

[Jim May]

Bob:
When I do as you say (in the immediate window)
It returns:

C:\Documents and Settings\Jim May\Application
Data\Microsoft\Excel\XLSTART

When I actually go there - there is NOTHING in the Folder

Actually I happen to know that my XLSTART can be found

C:\Program Files\Microsoft Office\OFFICE11\XLSTART
and includes my Book.xlt and my Personal.xls files

FWIW,,