How to recover data in spread sheet from xlsm file damaged by coding error
I made a coding error in changing a contant (string) to a simple public variable and corrupted my file.
The current version of data in one spread sheet is not backed up, and I seek to recover it
All developer code Is backed up
When I attempted to open the xlsm file, the Excel announcement screen opened, and reported the correct name of the file it was opening. After a long delay, it reported that it was "Opening and repairing" the file as "Attempt#1".
After 15 minutes, no progress had been achieved.
For example, can I recover this spreadsheet data, say by converting the xlsm file to xlsx (without opening it)?
Thanks!
Kelvin4
The current version of data in one spread sheet is not backed up, and I seek to recover it
All developer code Is backed up
When I attempted to open the xlsm file, the Excel announcement screen opened, and reported the correct name of the file it was opening. After a long delay, it reported that it was "Opening and repairing" the file as "Attempt#1".
After 15 minutes, no progress had been achieved.
For example, can I recover this spreadsheet data, say by converting the xlsm file to xlsx (without opening it)?
Thanks!
Kelvin4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually in the short interval, i opened a blank xl file and in Options, set the recalculate option to Manual (selection '4' as it happened).
Then uploaded offending xlsm file. It opened, and reported an ambiguous Constant .
By closing the reporter window using the top right red 'close X' interaction, the offending code remained visible and editable.
Thus the error was commented out, and the file seems to be alive and well with the rest of the code.
But, again thanks for your method which is more 'hands on' and flexible.
Kelvin
Kelvin