ExcelBanter - Macro file format not valid

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro file format not valid (https://www.excelbanter.com/excel-programming/288590-macro-file-format-not-valid.html)

Macro file format not valid

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

Macro file format not valid

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

Roger

In article , "Mark Rosenkrantz"
wrote:
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

--------------------------------------------------------------------

"Roger Bedford" wrote in message
...
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