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

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


"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

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