Save Access, Excel, and other Office Custom Toolbars

[TomCarnahan]

Is anyone aware of a way to save custom toolbars from Access, Excel, or other Office applications? Also, is there a way to transfer them between files (.mdb to .mdb, .xls to .xls)?

We have a renegade LAN Admin type who keeps losing our roaming profiles. When this happens, all custom toolbars and other customizations go "bye-bye". Since I invest a lot of time in customizing these to make my work easier, it is disconcerting to lose everything to the "bit bucket".

Thank you ahead of time for your help!

--- Tom

 

[mmtraining]

I take it you are saving the toolbars globally, so that the Word toolbars are saved into normal.dot, the Excel ones into personl.xls. These two files then get shot down by whatever happens on your network. (Is it a person who keeps causing this problem? If so have a nice quiet talk to him or her)

Normal.dot is where Word looks for your document templates (have a look in Word at Tools/Options/Saving... I have the German Version so am guessing)

Personl.xls is in your Excel Startup directory.

There are two solutions:
1. Find the two files and copy them somewhere else, so you can copy them back next time it happens.

2. Create templates which you use to create new files from now on.

To do this in Word, open normal.dot (I take it the file has your toolbars) and save it under another name. From now on, when starting to work on a new file, choose File/New and choose your template out of the list of templates.

To do this in Excel, open personl.xls and save it as an *.xlt file (choose this whilst saving out of the dropdown list of file types). From now on, when starting to work on a new file, choose File/New and choose your template out of the list of templates.

I am a bit stumped on the question of what to do with Access. I'll keep an eye on what others write

All the best,

Carol
Berlin

 

[TomCarnahan]

Carole,

Thanks for your taking the time to reply. I knew about personal.xls and normal.dot. What I don't know how to save are the actual custom toolbars in Excel and Access.

One thing I did was go into all my Office applications, change my custom toolbars and change some option settings. Then I went out and did a find on all files modified that day. I then sorted them with the newest first. From that, I learned the excel.xlb files and a variety of *.pip files are involved. I saved these in a zip file with file path info in a protected folder on the server. The next time the LAN folks lost my profile, I unziped those files back to there regular place. Unfortunately, it did not work. I had custom toolbars in Access, Excel, Outlook, PowerPoint, and the VBA Editor ... all lost. Because I saved the personal.xls and normal.dot, my macros got saved, but then I had to construct new toolbars to connect them to.

The other thing I don't understand is how toolbars can be moved from one file to another. I understand how it is done in Word. But Excel and Access are a mystery. Sometimes I have all my toolbars, then open a new .xls or .mdb, and the toolbars are gone. I would like to "transfer" them over to the new file or to an existing file where they don't exist.

Any thoughts?

Thanks!


--- Tom

 

[TomCarnahan]

Ooops ... I didn't read the part about saving personal.xls as a template ... I will try that.

I, too be interested in the Access part.

-- Tom

--- Tom