I wouldn't convert my files all at once. And if I had to share the workbook
with users of old versions of excel, then I'd want to make sure that I saved new
changes in the older version anyway.

I would bet that the vast majority (maybe all???) of your macros will work
as-is. I don't have anything in my personal.xla workbook that had to be
modified for xl2007.

But if you have any toolbars that are modified/created, you'll see them in the
Addins group of the ribbon.

And the biggest change in your upgraded life will be to get used to that
ribbon. Many (most power users???) have trouble transitioning. But lots of
people who have used the ribbon for a week like it better than the old toolbars.

This page has interactive help for going from an Excel 2003 menu item to its
2007 equivalent:

http://office.microsoft.com/en-us/ex...491511033.aspx

========
I did move my personal.xla file from its old location, though.

I opened xl2007, went to the VBE (alt-f11), showed the immediate window (ctrl-g)
and typed this:
?application.startuppath

To know where to move it.

ps.

My bet is that in a week or two, you'll be breathing easier--maybe muttering
questions on where to find stuff, but not in too bad shape.

(But your mileage may vary <vbg.)

pps.

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









Tondos wrote:

My company is converting to Excel 2007 from 2003 tomorrow. There has been no
planning, discussion, or thought given to this process. I am a Financial
Analyst that lives in Excel all day every day. I have thousands of files
with Financial Statements, models, scenarios, etc. and I have dozens of
macros created to run some automated processes.

My questions a Can anyone give me some general guidance on what I should
do first in 2007? Do I need to open and save as '2007' all of my existing
files? Will my 2003 macros in my 'Personal' macro book still work? I know
this seems silly, but I'm a nervous wreck, as I just don't have the time to
learn how to do every little thing (I have many custom toolbars with dozens
of custom buttons created to faciliate my work, can I still do this?)

Thanks
Tondos

--

Dave Peterson