Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When saving files, I get a back up of the same file saved as well | Excel Discussion (Misc queries) | |||
Excel file gets corrupt if saved in one particular drive | Excel Discussion (Misc queries) | |||
Keep saving corrupt Excel files | Excel Discussion (Misc queries) | |||
How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
Code for saving as a .prn file | Excel Programming |