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 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

[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.
--
Gary's Student


"Ingeniero1" wrote:

>
> 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
>
>
> --
> Ingeniero1
> ------------------------------------------------------------------------
> Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
> View this thread: http://www.excelforum.com/showthread...hreadid=537586
>
>

[Ingeniero1]

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

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

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

Thanks

Alex

[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.
--
Gary's Student


"Ingeniero1" wrote:

>
> Yes, I understand that, but wondered if I could 'copy and paste' what I
> already have done on another PC.
>
> Also, which I forgot to bring up and your post reminded me, I have
> several macros recorded on the other PC, for MS XL as well as for MS
> Word, and would like to copy them as well. Possible?
>
> Actuually, all my questions apply to both XL and Word, for which I have
> customized the menus, tool bars, and written macros.
>
> Thanks
>
> Alex
>
>
> --
> Ingeniero1
> ------------------------------------------------------------------------
> Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
> View this thread: http://www.excelforum.com/showthread...hreadid=537586
>
>

[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

On Sun, 30 Apr 2006 10:09:58 -0500, Ingeniero1
<Ingeniero1.2731um_1146409801.8639@excelforum-nospam.com> wrote:

>
>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