Hi,
The file you are after is Excel11.xlb. It is in C:\Documents and
Settings\<your username>\Application Data\Microsoft\Excel
Microsoft changes the .xlb file with each new version (Excel.xlb,
Excel8.xlb, Excel10.xlb and now Excel11.xlb)
After you set up your new machine with excel, start it once and the close
it. Then copy the file (Excel11.xlb) into the above location on your new
system.
One thing to watch is: If you have personal macros linked to any of the
toolbar buttons the Path to those macro must be the same on the new system.
So, you must either have exactly the same user name and copy your personal
procedures workbooks across to the same locations or use the work-around I
suggest below. For reference, your personal macros are stored in C:\Documents
and Settings\<your username>\Application Data\Microsoft\Excel\XLSTART and
your personal addins are in C:\Documents and Settings\<your
username>\Application Data\Microsoft\AddIns.
If you have a different username on the new system, you need to "relocate"
the file containing personal macros. Now to do this you need to:
1. Create a "common location" on both old and new systems (e.g.
C:/ExcelUpdate)
2. Open Excel on the old system and Unhide your personal macro workbook/s.
3. Use "Save As" to save the personal macro workbook/s to C:/ExcelUpdate
4. Close Excel. Now the Excel11.xlb file on your old system is linked to the
file/s in C:/ExcelUpdate.
5. Copy the personal macro workbook to C:/ExcelUpdate on the new system.
6. Copy the Excel11.xlb file to the new system in: C:\Documents and
Settings\<your username>\Application Data\Microsoft\AddIns.
7. Start Excel on the new system and Open the personal macros workbook (in
C:/ExcelUpdate).
8. Use "Save As" to save the personal macro workbook to C:\Documents and
Settings\<your username>\Application Data\Microsoft\Excel\XLSTART.
Now, Excel11.xlb on the new system is linked to the file/s located where
they should be (and will open automatically when you start excel).
If you have created personal addins files, or your workbooks uses functions
in your personal macros files, you can fix the connection to these easily
(they are the same as any other links between workbooks and can be updated by
opening each workbooks and Editing the Link.)
Now. All of the above will be simple is you use exactly the same name on the
new system. In this case, just copy all of the files (and folders) across
from:
C:\Documents and Settings\<your username>\Application Data\Microsoft\Excel
And
C:\Documents and Settings\<your username>\Application Data\Microsoft\AddIns
To the new system
And, as they say, "bobs your uncle"...