Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Weblog:   OpenOffice.org Saves my Day, Again
Subject:   OpenOffice saved my bacon with an Excel file
Date:   2003-05-02 10:44:43
From:   kbixler
Just last week, I had a similar problem with an Excel file. The data on the spreadsheet wasn't important, but the contents of the VBA macro I was writing would've taken me several hours to recreate. When I saved the spreadsheet at the end of the day (after having save multiple times throughout the day), I got a message saying that "Excel.exe has generated errors" and it quit. I rebooted, opened the spreadsheet, got the same error.


After about a half hour of poking around Microsoft's website it dawned on me that I could try opening it in OpenOffice. I opened it, did a "save as" and saved it to Excel format under a different name. When I re-opened it in Excel, some of the formatting was lost, but all my VBA code was there with all my changes, including the ones from the last save that killed Excel. I was very happy.
Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • OpenOffice saved my bacon with an Excel file
    2004-12-16 00:52:34  Bart.Hermans [View]

    Could you tell what open office is and where to get it?
    • Jonathan Gennick photo OpenOffice saved my bacon with an Excel file
      2004-12-16 05:47:41  Jonathan Gennick | O'Reilly AuthorO'Reilly Blogger [View]

      OpenOffice is an office suite similar in concept to Microsoft Word. You get word-processing, spreadsheeting, and I forget what all else. You can learn more by visiting http://openoffice.org.
Showing messages 1 through 2 of 2.