Building Macros in 2003 and Running in 2007

[L_Noor]

I am still using Excel 2003 and my client is using 2007.

I am building reports for my clients and need to include macros.
Currently, I am building the report in 2003, saving the file as 'Exce
2007 Macro-Enabled Workbook' to then build macros that the end user ca
use. However, in doing so, I am unable to edit this report as it i
saved in 2007.

Is there a way around it whereby I can save the macro in 2003 for it t
be compatible in 2007

 

[GS]

I am still using Excel 2003 and my client is using 2007.

I am building reports for my clients and need to include macros.
Currently, I am building the report in 2003, saving the file as 'Excel
2007 Macro-Enabled Workbook' to then build macros that the end user can
use. However, in doing so, I am unable to edit this report as it is
saved in 2007.

Is there a way around it whereby I can save the macro in 2003 for it to
be compatible in 2007?

All early version files can be opened in XL2007 and so there should be
no need to convert your XL2003 files unless you need xml to manipulate
the Ribbon. Otherwise, if your project makes custom menus/toollbars
then these will appear on the Addins tab in XL2007/2010 when the file
is opened.

If you need to open later version files in XL2003 there's a patch
utility available as a free download from MS. Note, though, that any
later version features will be stripped. IMO, you'd be better off
installing XL2007 on your machine so you have both late/early versions
to work with.

FYI, all my early version projects run just fine in XL2007/2010! Saves
me having to maintain 2 versions of the same app...