Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transfer Office Toolbar to new OS (97)

    Our company is getting ready to upgrade our systems from 95 to 2000. Doing so will wipe everything out.

    I can save everything I need but two things:
    1) The Office Shortcut bar
    2) Customized toolbars in Office Applications.

    Is it possible to save the ones I have customized? Or will I need to build them from scratch again?

    We are using Office 97.

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Transfer Office Toolbar to new OS (97)

    1) The Office tool bar will need to be updated on the new Version, I would NOT try and copy the Office 97 tool bar and replace the 2000 toobar.

    2) I believe if you copy the templetses that the Customized toolbars are defined in to the correct foler of Offce 2000, they should work. But with all of the changes made in 2000, you might want to take a look first. Also if macros are used, they will need to be updated.

    Others here will have more input with these ites, my use of custom tool bars is very limited.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Our version of Office will remain 97. Only the OS will be upgraded to 2000.

  4. #4
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Transfer Office Toolbar to new OS (97)

    In that case no problem. I did NOT read your post very well, I am getting that gray matter problem this AM.

    Are you just upgrading the OS or are you getting NEW machines also?

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    If you are just upgrading the OS, then you should not lose those if the system is upgraded. If they install the new OS of a clean disk and then reinstall the Office programs, then yes you will lose those customizations.

    For the Office shortcut bar, I would recommend dumping it and using the Win 2k quick launch bar. It works MUCH better than the Office short cut bar and does not cause the problems that the shortcut bar did.

    For the customized tool bars, I can tell you how to keep your Excel customizations. I don't know about the other Office applications. First, search your hard disk and find a file with the extension .xlb. The filename could be any one of several possibilities, but is probably your Logon User ID, or it might be something like EXCEL8. Save this file until after the upgrade. After the upgrade, go into Excel and customize a tool bar to create a new .xlb file. Search the hard disk and find where Excel created the file and what it named it. Replace this file with the one you saved, renamed to match the name on the upgraded system if necessary. After replacing the file, double click on the file from an Explorer window to open this file, then immediately close Excel. This should activate the customized tool bars in the .xlb file.
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Thanks for the tips. The Excel toolbar is the one I'm concerned about anyway.

    They are upgrading the OS's only. But, they're not actually upgrading, they are re-imaging with the new OS already in place.

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    If they are reimaging, then you will need to save the .xlb file and use the procedure I outlined.
    Legare Coleman

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Have you considered using the Office Resourse Tookit (ORK Tools)?

    I know that Office 2000 and 2002 have utilities for backing up and restoring ALL office settings (toolbars, menus, etc...).

    I don't know if that's available for Office 97, but you could check...

    HTH

  9. #9
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Where do you find the Office Resource Kit??

    For anyone who (like me) is obsessive about saving their customized toolbars when moving to a new machine, reinstalling, etc, here is some additional info:

    Word toolbar customizations are saved in NORMAL.DOT. In 97 usually located in C:Program FilesMicrosoft OfficeTemplates, in 2K C:WINDOWSApplication DataMicrosoftTemplates.

    PowerPoint toolbar settings are saved in a *.PCB file, analagous to *.XLB for Excel. The 97 version of this file is usually named [LogonName].PCB and is found in C:WINDOWS folder. 2K version is named PPT.PCB and is located in C:WINDOWSApplication DataMicrosoftPowerPoint folder. Open newly installed version of Powerpoint, make some toolbar changes, exit, copy old .PCB file over newly created one. The distinction is, an .XLB file is a worksheet you can open in Excel, while a .PCB file ("Office Data File") cannot be opened in PowerPoint.

    NOTE: above file locations based on WIN 98, location may vary in other versions.

    In testimony to MS's policy of consistency in Office, Access toolbar settings are not saved in a separate file but in the Registry. You can export the Registry key, then import it on new machine/installation to restore your toolbar settings (ONLY if using same version of Windows and recommended only for those familiar with editing Registry).
    Access 97 settings located at:
    [HKEY_CURRENT_USERSoftwareMicrosoftOffice8.0AccessS ettings]
    A2K:
    [HKEY_CURRENT_USERSoftwareMicrosoftOffice9.0AccessS ettings]
    The Settings key has a CommandBars subkey with all the toolbar customizations.

    Hopefully if the Office Resource Kit works as advertised it is simpler than keeping track of all these files & settings scattered all over the place...

  10. #10
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    The ORK for Office 97/98 can be downloaded here: http://www.microsoft.com/office/ork/appa/appa.htm.

    I didn't see the Save Settings Wizard - but there may still be a solution there for your need.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  11. #11
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Thanx, will check it out.

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Hi Mark:
    FYI. Although Word toolbar customizations are saved in normal.dot by default, you can save customized toolbars in any template. In fact, it is generally preferable to save styles, keyboard shortcuts, macros, toolbars, & Autotext in a specialized template. Then you can just take this template wherever you go, update it or copy these items to a new template.

    Cheers,

  13. #13
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Thanx for info. I knew about styles and macros in templates, did not know about toolbar customizations. I only recently have discovered how useful templates are in Word, especially when automating tasks. Not too long ago, about the only template I ever used in Word was Normal.dot. Now use 'em all the time.

  14. #14
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Office Toolbar to new OS (97)

    Hi Mark:
    Let me clarify something in case I mislead you. You can store customized toolbars in any template. However, if you customize the default toolbars (which are in normal.dot), then the customizations are in normal.dot. However, I find the best solution is to create a global template & put a completely customized toolbar (or more than one) in it, rather than use the built-in ones. Not only are they more useful that way, but you don't have to worry as much about the template succumbing to a virus.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •