Writing Excel macro in 2003 will not work in 2007

J

JanB

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.
 
S

Spreadsheet Solutions

JanB;

I think that when you provide us with some error code or detailed view of
that situation we could be of more help !!
 
D

Dave Peterson

Maybe the recipient didn't allow macros to run when they opened your file.

And you should save as a normal workbook (*.xls).

xl2007 will be able to open it.
 
M

Martin Brown

JanB said:
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
 
F

fisch4bill

Your friend my have the security level set too high. In Excel 2007, Click on
the Office Button > Excel Options > Trust Center > Trust Center Settings >
Macro Settings and make sure that the option "Disable all macros without
notification" is NOT selected. The option "Disable all macros with
notification" allows the user to enable macros. As Dave mentioned, if macros
aren't enabled, no matter what you code, it's not gonna work.

Hope this helps
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top