Help - a new user of Excel 2007

[Tom]

After installing Excel 2007, I found that Excel 2003 no longer works.
How can I solve the following two problems.

1. When Excel 2007 tries to load Personal.xls as Excel 2003 normally does,
it finds
that the file is not a binary file and prints the message, "This file is
not a
recognizable format". Any suggestion how I can convert Personal.xls to
Personal.xlsb as required by Excel 2007.

2. My own menu bar which holds all the buttons and stored under Excel11.xlb
no longer appears. Any help is much appreciated.

Tom

 

[Gord Dibben]

1. Open Personal.xls as you would any other regular workbook.

Save As Personal.xlsb to your XLSTART folder.

2. Not gonna happen.

See Ron de Bruin's site for working with the Ribbon and QAT

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP

 

[Tom]

Problem 1 - that's wonderful.
Problem 2 - it would be good if Microsoft can offer a converter.
Thanks for the tip Gord.

Tom

 

[Dave Peterson]

#2. I mainly use xl2003 and I've been too lazy to create an addin that utilizes
the ribbon.

But my personal.xla (it's been saved as addin) works fine in xl2007. But the
toolbars that it creates show up in the Addin Tab of the Ribbon.

You may be able to modify your personal.xls to create the toolbars when the
workbook opens (and destroy the toolbars when the workbook closes).

If that sounds ok...

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/archive/2010/03/27/deploy-me-simple.aspx

 

[Tom]

You gave me plenty of food for thoughts. Thanks for all those comments,
Dave.

Tom