VBA Saving code causes SAVED file to be corrupt
 

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 tries to open it,
using the same code in Excel 97 does not corrupt any of the saved
files.

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

Below is the code I use

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

'' File_Check

'' If fOk = 0 Then File_Check

ActiveWorkbook.Close
Windows(MasterBook).Activate

Is this a bug in Excel 2000

Thanks
Raymond Allan