Office settings for Word XP and 2003

  • Thread starter Thread starter KurtS
  • Start date Start date
K

KurtS

Hello all, I am looking for some information on the storing of values
set in the Tools>options of office applications (I need to look into
all but I think Word and Excel are probably the most important here) I
have looked into the RegOptions Macro, but that seems to be only a
small subset of the values that can be set.. Where is everything
else?

For Example the regOptions for Save are BackgroundSave and
DefaultFormat. However there are 16 different settings to change on
that tab... can all options be saved? another option is if I want to
hold on to the last 8 docs in my MRU where does this info get saved?

The reason I am doing this is we are trying to do some migration type
stuff in both a desktop environemnt and a CITRIX and would lik to have
our users do as little work as possible after they are moved to reset
their machines up.

Thanks so much in advance!

Kurt
 
In Word, many of the Tools|Options settings are stored in the Word data
key in the registry. The Word 2002(XP) data key is
\\HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Data. I believe
the Word 2003 data key is
\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Data, but I
can't confirm this at the moment.
 
Kurt

Following for Excel only.........

NOTE: some settings are workbook-specific and would be stored with the
workbook.

For other global stored settings..........

Do a file search for *.XLB which is the file that Excel stores some
preferences in(some are written to the registry, see below).

Menu and Toolbar customizations are saved in the *.XLB file.


A file search may turn up more than one *.XLB file. You will have
to determine which is correct one.

Note where they are and make a minor change to a Toolbar in Excel.
Save/close and see which *.XLB file was modified.

You can copy this file and save as a backup

If changing versions of Excel at the same time, you will find that
the *.XLB names are different. Make the appropriate name changes
and place in the proper folder.

xl97 is username8.xlb
xl2000 is excel.xlb.
xl2002 is excel10.xlb

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
 
Thanks garfield-n-odie...

I was having some issues saving those keys but got those worked out
between that and the other files like normal.dot I think I am covered
for the most part...

Kurt
 
Back
Top