Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel10.xlb
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 |
#2
|
|||
|
|||
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. -----Original Message----- 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 . |
#3
|
|||
|
|||
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. FGM wrote: 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. -----Original Message----- 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 . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|