2003 - 2007 custom macro and custom button restore.
Scott-
Forget what I said about the XLB file. Delete any file you created from it.
It doesn't seem to apply to you. If you had an add-in that worked in Excel
2003 browse for it in Excel 2007 as per my last message.
--
Jim
"Scott Sornberger" wrote in
message ...
| Darn program says "......excel11.xlb" is not a valid add-in!!!!
|
| "Jim Rech" wrote:
|
| I clicked "Office Button", "Excell Options", "Add-ins" and did not
find
| any that looked like mine.
|
| If the add-in is not known to Excel you should Browse to it after you
click
| the Go button.
|
|
| --
| Jim
| "Scott Sornberger" wrote in
| message ...
| |I clicked "Office Button", "Excell Options", "Add-ins" and did not find
any
| | that looked like mine.
| |
| | I opened the Excel11.xlb. There was an Excel10.xlb also.
| | I saved it as book1 in my user directory. I did see no change to the
| above
| | add-in list.
| |
| | I closed Excel and reopened Excel and went to find Excel12.xlb and it
did
| | not exist.
| | Add-in list showed no change which seems right since I had on
Excel12.mdb.
| |
| |
| |
| |
| | "Jim Rech" wrote:
| |
| | For the most part Excel 2003 macros run in Excel 2007 just fine. If
you
| had
| | modified your toolbars manually in Excel 2003 and those changes did
not
| | appear automatically in Excel 2007 on the Add-ins tab, I'd suggest
| manually
| | doing a File, Open of your Excel 2003 toolbar file (Excel11.xlb,
usually
| in
| | C:\Documents and Settings\<user name\Application
Data\Microsoft\Excel).
| |
| | That should load your Excel 2003 toolbars into the Add-ins tab and,
when
| you
| | close Excel, your Excel12.xlb should be updates to retain those
changes.
| |
| | --
| | Jim
| | "Scott Sornberger" wrote
in
| | message ...
| | |i have a number of macros and custom buttons in Excel 2003 that I
would
| | like
| | | to update to 2007. How may I accomplish this? Operating systiem
is XP
| | | Professional.
| | | I did use the "Microsoft Office 2003 Save My Settings Wizard"
before
| the
| | | company updated us to 2007.
| |
| |
| |
|
|
|
|