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
Bookmarks