+ Reply to Thread
Results 1 to 3 of 3

saveas corrupted my workbook

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    18

    saveas corrupted my workbook

    ok so i made a mistake and coded saveas instead of savecopyas and now the workbook is corrupted and i cant open it. the data in the workbook is junk but i have spent 8 hours today working on the vba code in this file and i really really dont wanna have to rewrite it all. i know the erronious saveas command was supposed to be saving my xlsm file to another xlsx file in the format xlOpenXMLWorkbook, but since i had saveas instead of savecopyas it seems to have overwritten this file... but didn't rename it now excel wont open the file at all. when i open it in Notepad++ in the garbage i can see references to both the junk data set and the macro comments so im assumeing my data is all still there just excel now doesn't know how to open it. am i boned or can this be fixed? This is the file in question there is nothing i would consider confidential in it just a few made up names2014 Hours Sample.xlsm

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: saveas corrupted my workbook

    I was able to open as a .csv and then saved it as an .xls file. Appears to be intact. Here is the .xls file renamed Timmathews.xls
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: saveas corrupted my workbook

    you are my hero, i need to save this to dropbox or somewhere similar so i can pull old revision...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 05-22-2012, 04:14 PM
  2. use existing creation date of workbook with newly created .saveas workbook
    By dwr0211 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2011, 12:42 PM
  3. Corrupted links to PERSONAL.XLS workbook
    By ez2rmbr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2011, 02:22 AM
  4. Recovering code from corrupted workbook
    By tlewis3348 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2009, 09:38 AM
  5. Replies: 0
    Last Post: 11-08-2007, 03:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1