Copy customized toolbars from old PC to new PC
 

I have copied the *.xlb file to the users folder on his new PC
( C:\Documents and Settings\username\Application Data\Microsoft\Excel)
However - the changes are not showing in Excel. I can force new spreadsheets
to open after I have opened the *.xlb file - but how do I add the changes for
all new (or existing) spreadsheets?
Thanks,

Copy customized toolbars from old PC to new PC
 

When you copied the *.xlb file to that folder was there already one there to
overwrite?

What was the version of the *.xlb file that you copied over?

e.g. was it Excel10.xlb or Excel11.xlb or?

How many *.xlb files do you have in that folder currently?


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 09:00:02 -0700, dcallaway
wrote:

I have copied the *.xlb file to the users folder on his new PC
( C:\Documents and Settings\username\Application Data\Microsoft\Excel)
However - the changes are not showing in Excel. I can force new spreadsheets
to open after I have opened the *.xlb file - but how do I add the changes for
all new (or existing) spreadsheets?
Thanks,

Copy customized toolbars from old PC to new PC
 

Excel11.xlb - there was not a file that needed to be overwritten - this is on
a freshly loaded PC - Excel had never been opened! No other *.xlb files in
the folder.
I'm running XP with Office 2003

"dcallaway" wrote:

I have copied the *.xlb file to the users folder on his new PC
( C:\Documents and Settings\username\Application Data\Microsoft\Excel)
However - the changes are not showing in Excel. I can force new spreadsheets
to open after I have opened the *.xlb file - but how do I add the changes for
all new (or existing) spreadsheets?
Thanks,

Copy customized toolbars from old PC to new PC
 

There were no other copies of *.xlb - the version is Excel11.xlb. There were
no other *.xlb files. This is a brand new load of XP with Office 2003



"Gord Dibben" wrote:

When you copied the *.xlb file to that folder was there already one there to
overwrite?

What was the version of the *.xlb file that you copied over?

e.g. was it Excel10.xlb or Excel11.xlb or?

How many *.xlb files do you have in that folder currently?


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 09:00:02 -0700, dcallaway
wrote:

I have copied the *.xlb file to the users folder on his new PC
( C:\Documents and Settings\username\Application Data\Microsoft\Excel)
However - the changes are not showing in Excel. I can force new spreadsheets
to open after I have opened the *.xlb file - but how do I add the changes for
all new (or existing) spreadsheets?
Thanks,

Copy customized toolbars from old PC to new PC
 

Maybe stored somewhere other than standard location.

Do a file search for *.xlb

See if you have more than one.

If so, take note where they are and sizes.

Open Excel and make a couple of changes to a Toolbar or Menu.

Close Excel and see which *.xlb file gets changed.


Gord

On Thu, 27 Sep 2007 10:04:00 -0700, dcallaway
wrote:

There were no other copies of *.xlb - the version is Excel11.xlb. There were
no other *.xlb files. This is a brand new load of XP with Office 2003



"Gord Dibben" wrote:

When you copied the *.xlb file to that folder was there already one there to
overwrite?

What was the version of the *.xlb file that you copied over?

e.g. was it Excel10.xlb or Excel11.xlb or?

How many *.xlb files do you have in that folder currently?


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 09:00:02 -0700, dcallaway
wrote:

I have copied the *.xlb file to the users folder on his new PC
( C:\Documents and Settings\username\Application Data\Microsoft\Excel)
However - the changes are not showing in Excel. I can force new spreadsheets
to open after I have opened the *.xlb file - but how do I add the changes for
all new (or existing) spreadsheets?
Thanks,

Copy customized toolbars from old PC to new PC
 

The XLB will not work correctly if the pathname is not exactly the
same. <username is different.

The XLB file is in the same directly as the XLSTART directory
for where your Excel is started;.
http://www.mvps.org/dmcritchie/excel/toolbars.htm

Take a look at http://www.mvps.org/dmcritchie/excel/barhopper.htm
to fix entries or to generate a spread sheet page that you could use
John Walkenbach's Menu Maker (tip 53) to regenerate.
http://j-walk.com/ss/excel/tips/tip53.htm

Can also be used with Ron de Bruin's code to create a working menu
for Excel 2007.
http://www.mvps.org/dmcritchie/vista....htm#excel2007
http://www.rondebruin.nl/qat.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"dcallaway" wrote in message ...
Excel11.xlb - there was not a file that needed to be overwritten - this is on
a freshly loaded PC - Excel had never been opened! No other *.xlb files in
the folder.
I'm running XP with Office 2003

"dcallaway" wrote:

I have copied the *.xlb file to the users folder on his new PC
( C:\Documents and Settings\username\Application Data\Microsoft\Excel)
However - the changes are not showing in Excel. I can force new spreadsheets
to open after I have opened the *.xlb file - but how do I add the changes for
all new (or existing) spreadsheets?
Thanks,