JanB wrote:
I have only 2003 and will help a friend of mine. He has only 2007. When I
write a simple macro in 2003, it will not work in 2007

What format should I save the file

( the macro is simple as Copy one row of data and paste it in another sheet)

Hope these genuine group will find a solution.

That sort of thing will probably work - at least if he enables running
macros. XL2007 is a lot less trusting of macros in worksheets.

However, anything complex with shapes, charts or selecting files will
fail horribly as certain things were gratuitously changed or withdrawn.

It is quite possible to write a core spreadsheet fully compatible with
all versions of Excel to load XL2003 or XL2007 components as needed
depending on the runtime environment. This may be needed because some
XL2003 constructs give a compile error on 2007 and vice versa.

Regards,
Martin Brown