View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
PG
 
Posts: n/a
Default how do I import custom Excel buttons?

In xl2003/winXPPro, I found mine in the same path.

"Dave Peterson" wrote:

ps. Remember to look through hidden folders for hidden files.

pps. My excel11.xlb (xl2003/winXP home) is in:
C:\Documents and Settings\(usernamehere)\Application Data\Microsoft\Excel

PG wrote:

Unfortunately Excel11.xlb was the only one I found (besides Excel.xlb in an
old folder from the last PC change).

I'm beginning to think they were being kept in some type of "recent" file,
but not truly saved anywhere. It's looking like I should have saved the
toolbar, then I would have a *.xlb file to transfer as you suggest.

Looks like I'll have to recreate the buttons.

"Dave Peterson" wrote:

I don't use workspaces, so I don't have a guess.

Maybe if you search for all the *.xlb files, you'll be able to find the one you
want.

PG wrote:

both are 2003. old has SP1, new SP2.

I had copied the Excel11.xlb file to the same path and directory, but no
buttons. Now I may be in a worse pickle. I appear to have stumbled on an
older .xlb file. I double clicked it, and now my old PC does not have the
buttons.

What about the resume.xlw file? I remember having to save the workspace to
make the buttons appear, but I do not have any buttons when I open the
resume.xlw file either.

"Dave Peterson" wrote:

Is it the same version of excel?

If yes, then you may get lucky by just copying your *.xlb file to your new pc.

I like to modify a toolbar to find the correct *.xlb (both on the old and new
pc). Then use windows start button|search to get the correct location for both
the "sending" and "receiving" pcs.

Remember if you have macros assigned to these buttons, you'll want to copy the
workbooks to the other pc--and keep them in the same identical location--or
you'll be reassigning buttons to procedures.

PG wrote:

I just got a new computer at work. I had several custom-made buttons
assigned to macros on the old computer. I have successfully moved the macros
over, but I can't find where the custom buttons are saved, or how to import
them.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson