Excel10.xlb

[FGM]

I think it has to do with the Excel10.xlb. I copied the
personal.xls and the Excel10.xlb from my work computer to
my home computer so that I would have the same menu and
macros at home.

I put Personal.xls in the XLStart just like I have it at
work.
Now when I open a new file in Xcel and personal.xls opens
as a hiden file (as it should). However, when I press on
the macro button on the toolbar or in the menu it says
that personal.xls is already open and can not open two xls
files with the same name. Unfortunately, now the same
thing is happening at work.
If I take Personal.xls out of XLStart then the macro will
work. If I leave it in SLStart and make a new macro
button it will work.
Therefore, this seems to be something with a pointer in
the menu item but nothing has moved on my work drive.
I did open the Excel10.xlb file by mistake and think I
remember hearing that you are not suppose to open a xlb
file.
Does anyone have any answers other than make all my menus
and toolbars over again that use Personal.xls macros.

Thank you

 

[FGM]

Found a backup of the xlb file and copied that on and it
works. Therefore I can only think that it was because I
openned the xlb file. Would be interested in comments
from others.

 

[Dave Peterson]

My guess....

You had an existing personal.xls file somewhere on your pc.

Excel is pretty smart.

Depending on how you upgraded, you could have multiple XLStart folders hanging
around. Excel is smart enough to look at all of them.

I'd use windows start button|search (or find) to look for XLStart (and later
personal.xls) to see if you can find more than one.

When I did this, I found the one that excel "sees" as current. I moved all my
stuff into that one and deleted the other XLStarts.

I found this "real" one this way:

Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this in that window and hit enter:
?application.startuppath

For me (win98/xl2002), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

For me, my *.xlb file is in:
C:\WINDOWS\Application Data\Microsoft\Excel

The way I find this is more convoluted.

I make a minor modification to my toolbar and then close excel.
Then I search for *.xlb and note the one that has the time/date stamp that I
want.

I move the one I want into that folder and delete the others.