You don't need to save any of the Excel default add-ins like atvbaen.xla
They will be installed with 2003 if you pick typical installation.
As far as everything else goes...................
Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.
Excel 97.....username.xlb
Excel 2000...Excel9.xlb
Excel 2002...Excel10.xlb
Excel 2003...Excel11.xlb
Note: there may be other customizations you want to transfer at the same time.
NOTE: some settings are workbook-specific and would be stored with the
workbook.
For other global stored settings..........
Screen layout, color info, checked Add-ins and many ToolsOptions
settings are stored in the Registry, not in the *.XLB file.
To see some of what's stored in the Registry have a peek at this
section in it, if you feel comfortable.
HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\E xcel\Options
XX is your version of Excel...8,9,10,11
Assuming you are aware of the precautions taken when editing the
Registry and know how to restore a recent backup of same.......
If not, maybe have a look here first...scroll down to "Registry
editing tips"
http://www.activewin.com/tips/reg/index.shtml
Export all these keys(as a branch group) to a .REG file so's you can
back them up.
Note also: you may want to move over your *.ACL(autocorrect files) and any
*.DIC files.
For a more comprehensive listing see Dave Peterson's posting at
http://snipurl.com/8r7x
Gord Dibben Excel MVP
On Mon, 16 Oct 2006 16:24:01 -0700, havocdragon
wrote:
Nothin at all? Wow, my first dissappointment in this site in like 3 years ive
been using it =).
Theres gotta be a few things I need to save like, personal.xls and
atvbaen.XLA right?
"havocdragon" wrote:
So my work is upgrading from office 2000 to 2003, they have a page to upgrade
this and its not too difficult so I can live with that part.
The real question I have is...I have lots of persnal workbook macros,
functions...add ins etc etc. What all do I need to save to ensure all my user
settings will transition over to the new excel?
Gord Dibben MS Excel MVP