Macro file format not valid

  • Thread starter Thread starter Roger Bedford
  • Start date Start date
R

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
 
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)
 
Back
Top