G
Guest
How can I copy Macros from Excel 2000 to Excel 2003. Where are they stored?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Macros are stored in workbooks. So if you copy the workbook, you'll copy the
macros.
macros.
G
Guest
I'm talking about a macro (inserted on an Excel toolbar) which opens a workbook.
G
Guest
I think it is stored in the "Personal Macro Workbook". Do you know where that is stored? Thanks for your help so far.
G
Gord Dibben
Moya
Do a Start>Search>Files and Folders for "XLSTART"(no quotes) folder.
Your Personal.xls file should be in there. If you find it, you can copy it to
your 2003 XLSTART folder.
You may have more than one XLSTART folder.
The standard folder for Office 2000 is
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
If you find it(Personal.xls), you can copy it to your 2003 XLSTART folder.
You will have to re-create a button on your new Toolbar in 2003 also.
Gord Dibben Excel MVP
Do a Start>Search>Files and Folders for "XLSTART"(no quotes) folder.
Your Personal.xls file should be in there. If you find it, you can copy it to
your 2003 XLSTART folder.
You may have more than one XLSTART folder.
The standard folder for Office 2000 is
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
If you find it(Personal.xls), you can copy it to your 2003 XLSTART folder.
You will have to re-create a button on your new Toolbar in 2003 also.
Gord Dibben Excel MVP
D
David McRitchie
Your toolbars are stored in an *.XLB file. Search your
system the file if updated every time Excel is closed. You will
have to unhide your file extensions in order to find the *.XLB file
in use.according to the datetimestamp. Start at
http://www.mvps.org/dmcritchie/excel/toolbars.htm#emergency
Since you are going from one version of Excel to another I would
manually reenter toolbar menus and icons. But you could possibly
replace your *.xlb file on the new system with that from your old
system. To document what you have see
http://www.mvps.org/dmcritchie/excel/barhopper.htm
Put everything in place in the same pathnames if possible *before*
opening Excel. You do not want to open Excel and take your
information directly from a backup file that can get you into more trouble.
Most important is that your personal.xls file be in place
in the proper location so that when Excel is opened it will be the
file that is opened from you XLSTART directory.
system the file if updated every time Excel is closed. You will
have to unhide your file extensions in order to find the *.XLB file
in use.according to the datetimestamp. Start at
http://www.mvps.org/dmcritchie/excel/toolbars.htm#emergency
Since you are going from one version of Excel to another I would
manually reenter toolbar menus and icons. But you could possibly
replace your *.xlb file on the new system with that from your old
system. To document what you have see
http://www.mvps.org/dmcritchie/excel/barhopper.htm
Put everything in place in the same pathnames if possible *before*
opening Excel. You do not want to open Excel and take your
information directly from a backup file that can get you into more trouble.
Most important is that your personal.xls file be in place
in the proper location so that when Excel is opened it will be the
file that is opened from you XLSTART directory.
D
David McRitchie
Hi Moya,
Since your success was indicated before I mentioned the toolbars,
under customize, right click on one of the icons that runs a macro from
your personal.xls file to see that you just see personal.xls!macroname
and not a full pathname.
Since your success was indicated before I mentioned the toolbars,
under customize, right click on one of the icons that runs a macro from
your personal.xls file to see that you just see personal.xls!macroname
and not a full pathname.