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?