Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corrupt Excel File
I have an excel application that is about 6.5M in size. I run this
application once a week to pull in data from a number of files, it updates the worksheets, then copies all the worksheets unto a new workbook. The problem is that sometimes when I save the base file (the one with the macro in it) when I open it to process data again the file does not open. I receive an excel message that the file is being repaired, but then get a message that the errors are too extensive. I am at a loss on how to troubleshoot this. Could file size be an issue? This is a new problem that was introduced after adding more tabs and data to the spreadsheet. Luckily, I saved a version that I can open up and run with then save it as another name so I don't lose it. The problem is I am going to need to make code changes. and I don't want to lose 1500 lines of code. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Corrupt File | Excel Discussion (Misc queries) | |||
Excel - Corrupt File / Urgent | Excel Discussion (Misc queries) | |||
Corrupt Excel File | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel file or sheet is corrupt | Excel Discussion (Misc queries) |