software

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: www.excelforum.com/member.php...foamp;userid=4029
View this thread: www.excelforum.com/showthread...hreadid=537586If 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 = quot;Garys Studentquot;
.StandardFont = quot;Arialquot;
.StandardFontSize = quot;10quot;
.DefaultFilePath = quot;C:\Documents and Settings\Owner\My Documentsquot;
.EnableSound = False
.RollZoom = False
End With
End Subis 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 Studentquot;Ingeniero1quot; wrote:

gt;
gt; Just bought a new PC; this one with Win XP and XL 2003. The old one had
gt; Win ME and XL 2002.
gt;
gt; Each time, whether for a new PC, or a new installation on an existing
gt; PC, or whatever, I have had to set my customized tools bars, options,
gt; etc., - from scratch.
gt;
gt; Is there a way, such as files where my preferences and customized
gt; options reside and that can be copied from one PC and pasted to
gt; another, so that when I start XL the menus, tool bars, options, etc.
gt; look as my older XL?
gt;
gt; Thanks
gt;
gt; Alex
gt;
gt;
gt; --
gt; Ingeniero1
gt; ------------------------------------------------------------------------
gt; Ingeniero1's Profile: www.excelforum.com/member.php...foamp;userid=4029
gt; View this thread: www.excelforum.com/showthread...hreadid=537586
gt;
gt;


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: www.excelforum.com/member.php...foamp;userid=4029
View this thread: www.excelforum.com/showthread...hreadid=537586You 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 Studentquot;Ingeniero1quot; wrote:

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


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 Toolsgt;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\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 quot;Registry
editing tipsquot;

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

snipurl.com/8r7xGord Dibben Excel MVP

On Sun, 30 Apr 2006 10:09:58 -0500, Ingeniero1
gt; wrote:

gt;
gt;Just bought a new PC; this one with Win XP and XL 2003. The old one had
gt;Win ME and XL 2002.
gt;
gt;Each time, whether for a new PC, or a new installation on an existing
gt;PC, or whatever, I have had to set my customized tools bars, options,
gt;etc., - from scratch.
gt;
gt;Is there a way, such as files where my preferences and customized
gt;options reside and that can be copied from one PC and pasted to
gt;another, so that when I start XL the menus, tool bars, options, etc.
gt;look as my older XL?
gt;
gt;Thanks
gt;
gt;Alex

Gord Dibben MS Excel MVP