VBA Saving code causes SAVED file to be corrupt

R

Raymond Allan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data files are corrupt after saving from VBA - Excel 2000 7
Hiding an Excel file using VBA 1
Save with ref. to cell A1 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
vba code does not run 3
No New Workbook Annoyance 2
Simplify save code 11
SaveAs in Excel97-2003 format 3

Top