Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Wisconsin, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy Toolbars (Office 2000 Prem SR1)

    I made several customizations to my Excel 2000 Toolbars but now I have to reload my OS (Win 2K Pro). Is there a template stored somewhere that I can copy and then replace on the newly installed Office so I don't have to do the customization all over? With Word you can copy the "Normal.dot" but I can't seem to find a similar file for Excel. (I thought Excel.xlb and Excel.pip would work but it didn't - tested that out on another machine.

    Any help is greatly appreciated.

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Copy Toolbars (Office 2000 Prem SR1)

    muskytaz

    I think if you copy the Excel8.OLB, or maybe its 9 in Excel 2000, file you should get your customization.

    But I was told that the new versions might not have the same /OLB structure. If anyone knows better let me know.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: Copy Toolbars (Office 2000 Prem SR1)

    Toolbar settings are saved in the EXCEL.XLB file. According to the Help file, "Customized toolbars (Excel.xlb)" are saved in the RootOSProfilesUser_nameApplication DataMicrosoftExcel folder. I'm using WIN 98 not WIN 2K, so my .XLB file is located in the C:WINDOWSApplication DataMicrosoftExcel folder. Location will vary based on OS and User Profile in effect. If not sure of correct location on new system, after installing Office, open Excel, make some toolbar changes, exit Excel, search for newly updated .XLB file to determine its location, then copy over with your old .XLB file.

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

    Re: Copy Toolbars (Office 2000 Prem SR1)

    As MarkD said, the toolbar customizations are kept in the .xlb file. Depending on the Excel version, this could be Excel.xlb or Excel8.xlb or possiblby some other variation for older versions. I just want to add one thing to what MarkD said. After reinstalling and putting the .xlb file back where it belongs, you have to do one other thing to get it to take effect. You must double click on the .xlb file to open it, then just close Excel.
    Legare Coleman

  5. #5
    New Lounger
    Join Date
    Jan 2002
    Location
    Wisconsin, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Thank You all - see for final solution

    Thanks for the advice. I didn't think it was Excel.xlb because I tried that already. But the tip from Legare to double click on the Excel.xlb file was the start to the final remedy. I did open that file then closed Excel but it didn't bring up the saved toolbar when I opened Excel again. So I did it again and this time I opened the Customize feature, closed it and then closed Excel. Walla it worked.

    I'm very happy now.
    Thanks so much to all for your input.
    Taz

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Thank You all - see for final solution

    One further advice.

    It is easier to attach customized toolbars to a workbook. That way it is very simple to carry over that particular toolbar: just open the workbook on the system you want the toolbar added to.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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