Hi,

I am using Excel 2000

I have a routine which goes through around 20 sheets and moves each
sheet to a new workbook and then saves it, closes the workbook and
then deletes the sheet from the master workbook, this code works fine
but each resultant file crashes Excel when the user or I try to open
it.

I have changed settings in the options to save only as Excel 2000,
Excel 97 etc. but still the data files are corrupt

Using the same code in Excel 97 does not corrupt any of the saved
files, is this a bug in Excel 2000 !!

I even added a routine to check that the files were fully saved before
processing the next file.

Below is a snippet of the code I use

ActiveWorkbook.SaveAs filename:=ThisFolder & fName,
FileFormat:=xlNormal

'' DoEvents

'' File_Check

'' If fSavedOk = 0 Then File_Check

ActiveWorkbook.Close

'' ActiveWorkbook.Close SaveChanges:=false

Windows(MasterBook).Activate

Thanks
Raymond Allan