XL Macro from 2003 used in XL 2007

**filiptahir** · 07-03-2009, 09:27 AM

Hello fellow experts!

Im currently using a macro that has been written in microsoft excel 2003 and we've recently upgrade some of our computers to 2007.

My question is: Is it possible to "re-save" the macro as a microsoft excel 2007 file while still being functional?

Best wishes,

Filip T

**romperstomper** · 07-03-2009, 09:45 AM

If you have only upgraded some of your computers, it would make more sense to leave the macro file in 2003 format I would suggest.

**filiptahir** · 07-03-2009, 10:05 AM

Mm, you have a clear point indeed. The idea is that they'll all be upgrade at some point, how far ahead is beyond me. However, if we were to try and convernt the macro to 2007, are you aware of any simple ways to do it?

**romperstomper** · 07-03-2009, 10:08 AM

Just save it as an .xlsm or .xlsb file. Most macros will simply work in both versions, depending on what they do. (Application.Filesearch is no longer available in 2007, and somteimes chart code needs a bit of tweaking for example).

**filiptahir** · 07-04-2009, 10:26 AM

Alright Romperstomer,

Im not at the office at the moment but I will give it a try on monday and let you know how it works out!

Thanks again!

Have a nice weekend!