Macro file format not valid

[Roger Bedford]

I am trying to run a macro on D:\ drive in Excel 5. I also have a C:\ drive
not partitioned which is running Excel 2002.

When I try to run a macro in Excel 5 that is not very basic I get the
following message:

Run-time error '1004';
Work03.xls: file format is not valid.

However if I have a very basic macro it will run.

Any suggestions will be greatly appreciated,

Roger

 

[Mark Rosenkrantz]

Roger;

It depends on what you do, but files saved in XP and 2000 - I thought Excel
97 as well - may not be recognized as vaild Excel fileformats and thus you
receive an
error.
So if you refer to such a fileformat in your macro, it won't work.

Mark.

More Excel ? www.rosenkrantz.nl or (e-mail address removed)

 

[Roger Bedford]

Hi Mark, thanks for your suggestion. I'll give it a try.

Roger