Ron and Dave,

Thanks so much to both of you. I've been reading your expert advice for a
long time, and I really value what you have to say. Your advice has helped
me countless times! Thank you very much.

Per your first point, Ron, I've been pushing to upgrade to 2007 for 18
months, utilizing a logical test-phased approach. That way we could iron out
the kinks and become familiiar with it. Especially since I'm the only true
power user in the group. Well...what can I say? I'm not the boss, and I
don't necessarily make this level of decision (I make the Finance decisions.)

Anyway, I already run two PC's and a virtual, so I should be covered there,
as I'm definitely going to need to keep 2003 for some time until we're all up
to speed.

And as soon as the install is done, I'll check out your sites for the
customization, add-ins, etc.

Thanks, again, guys, I really appreciate it! (and I'll probably be asking
again over the next few weeks!)

"Ron de Bruin" wrote:

Hi Tondos

First why do you not convert one machine first to test it ?????

You can run your 2003 files in 2007 without any problems for 99.99%
There are no toolbars anymore in 2007 but if it is correct you can find the buttons in the Add-in tab.

Maybe you like this option to add a custom menu in the QAT for the macros in your personal file
http://www.rondebruin.nl/qat.htm

In Excel 2007 your personal file is named personal.xlsb and not xls
but if you copy the xls in the XLstart folder it will open this file and you can use the code.

But I suggest to do a SaveAs as personal.xlsb
Open the personal.xls
Unhide the file
SaveAs as xlsb
Hide
Save

You can convert all your 97-2003 files if you want like this
See the last section on this page
http://www.rondebruin.nl/2007filesin2003.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Tondos" wrote in message ...
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