×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Corrupted Excel 97 Workbook.

Corrupted Excel 97 Workbook.

Corrupted Excel 97 Workbook.

(OP)
I have been writing a reasonably complex Excel VBA routine to produce a report on one worksheet from particular data found on some of the other worksheets in the workbook.  Two weeks ago, after about 10 hours of work, I almost had it completed, but I decided to put it away for the Xmas vacation. Then today, when I got back, I found that all but the first saved version was corrupted and wouldn't load into Excel 97!

When I try loading it in Excel 97 or 2000, with macros enable or disabled, Excel locks up with a white spreadsheet.  The strange thing is that I can view the data in Quick View and even import the data into Word!  The problem is I need the VBA code, not the data!  Is there anyway I can extract some of the worksheets or the VBA code without requiring that the workbook first be opened in Excel?

Now for my rant!  I did save my work and each save to a different file, so I would have a "bread-crumb" trail, just in case!  I didn't exited Excel during the last 10 hour effort, so I had no idea that Excel had screwed up my work.  I find it strange that during that whole time that Excel never once had a problem with my in-memory workbook version.  However all those versions, save the first, are all worthless!  Sense Excel locks up when I load any of these versions, I believe that if I had tried to load any of them to test the written file, Excel would have locked up and my work would be lost in spite of my best efforts.  I don't think this is my fault.  Instead, I blame Microsoft for shoddy file saves.  This isn't the first time that this has happened, but the last time this happened was many version ago.

I just had to get that said.  I know that it's amazing that Excel works as well as it does, but you'd think that they would at least save your file correctly!  If you can't trust the save, why put the data in in the first place.  Yes, it doesn't fail every time, but it shouldn't fail and not somehow check the validity of the save!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close