ps. A couple of the biggest changes in xl2003 to xl2007:

Application.filesearch was killed.

Ron de Bruin shares some alternatives he

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

And procedures with objects/Charts may not work like in xl2003.

On 05/14/2010 09:55, Dave Peterson wrote:
Macros live in workbooks. So you shouldn't have any trouble
transferring the macros to the new version of excel.

But the question that remains will be "do your macros run as intended in
xl2010?".

Without knowing anything about your macros, I'm gonna guess that you
won't have any significant problem.

But the only way you'll know for sure is to test them using xl2010.

Maybe you can ask your boss to be the first person to get xl2010 (on a
separate pc) or installed on a virtual pc or even installed on the same
pc (keeping xl2003 alive and kicking).

Then you'll be able to test all the functions of not just your macros,
but the other workbooks you (and your co-workers) rely on.

If you have trouble, you may be able to ease the pain for others by
fixing the macro or talking to the developers of the other workbooks so
that they can be working when the rest of your team cuts over.

If I were your boss, I don't think I'd want to go into a situation with
my eyes closed where mission-critical tools are broken.



On 05/14/2010 06:41, Wanna Learn wrote:
Hi I have excel 2003 Professional. THis summer we are getting
Microsoft 2010
and I am concerned regarding all the add in and macros and reports I have
created. Will I be able to transfer all my macros, add ins and files to
excel 2010.
thanks