Is there a way to 'copy' my XL settings to another PC?

[Ingeniero1]

Just bought a new PC; this one with Win XP and XL 2003. The old one ha
Win ME and XL 2002.

Each time, whether for a new PC, or a new installation on an existin
PC, or whatever, I have had to set my customized tools bars, options
etc., - from scratch.

Is there a way, such as files where my preferences and customize
options reside and that can be copied from one PC and pasted t
another, so that when I start XL the menus, tool bars, options, etc
look as my older XL?

Thanks

Ale

 

[Gary''s Student]

If you are going to establish the setting manually once, consider turning on
the macro recorder when you do it:

Sub Macro1()
With Application
.ReferenceStyle = xlR1C1
.UserName = "Garys Student"
.StandardFont = "Arial"
.StandardFontSize = "10"
.DefaultFilePath = "C:\Documents and Settings\Owner\My Documents"
.EnableSound = False
.RollZoom = False
End With
End Sub


is just a small sample of what you can record.


Once you have the macro defined to your satisfaction, you can run it on any
new machine you are given.

 

[Ingeniero1]

Yes, I understand that, but wondered if I could 'copy and paste' what
already have done on another PC.

Also, which I forgot to bring up and your post reminded me, I hav
several macros recorded on the other PC, for MS XL as well as for M
Word, and would like to copy them as well. Possible?

Actuually, all my questions apply to both XL and Word, for which I hav
customized the menus, tool bars, and written macros.

Thanks

Ale

 

[Gary''s Student]

You might try to copy your EXCEL10.xlb or EXCEL11.xlb file to the new
computer. I have tried this in the past, but it has never been fully
successful. Thats why I use the macro approach.

 

[Gord Dibben]

Alex

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.

Before reading further.......

Transferring your *.xlb file from 97 to 2003 will reduce the functionality
of new version menu items, although most of them can be dragged onto the old
menu.

Read on.........

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 Tools>Options
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\Excel\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

Just bought a new PC; this one with Win XP and XL 2003. The old one had
Win ME and XL 2002.

Each time, whether for a new PC, or a new installation on an existing
PC, or whatever, I have had to set my customized tools bars, options,
etc., - from scratch.

Is there a way, such as files where my preferences and customized
options reside and that can be copied from one PC and pasted to
another, so that when I start XL the menus, tool bars, options, etc.
look as my older XL?

Thanks

Alex

Gord Dibben MS Excel MVP