View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ariel Ariel is offline
external usenet poster
 
Posts: 38
Default Where's the Personal.xls in Excel 2003?

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

"Dave Peterson" wrote:

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.

Ariel wrote:

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?


--

Dave Peterson