Can you use VBA code to access a corrupted file?

[Slape]

I have a file which I've tried numerous ways to open:

Excel's Recovery method to resore
Renaming
Moving from my OneDrive to desktop
Outside Software
Safe mode in Excel
Changing extension from .xlsx to .xls

As far as I know I have tried everything and wondering if it's possible to duplicate with VBA.

Thanks for your help

 

[oldbrewer]

is it corrupted, or is it password protected ?

 

[Slape]

Corrupted because there is no password

 

[oldbrewer]

a specialist data recovery company is maybe your only option then....

 

[Slape]

I already did and the only thing I can think of is trying VBA

 

[oldbrewer]

If File Recovery mode doesn't start, try using this manual process to recover your workbook:

• Click File > Open.
• Click the location and folder that contains the corruptedworkbook.
• In the Open dialog box, select the corrupted workbook.
• Click the arrow next to the Open button, and then click Open and Repair.

More items...



[h=3]Repair a corrupted workbook - Excel - Office Support - Office 365[/h]<cite class="iUh30" style="color: rgb(0, 102, 33); font-style: normal; font-size: 14px;">https://support.office.com/.../repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-8...</cite>

 

[oldbrewer]

https://www.techradar.com/news/soft...ecover-a-corrupt-microsoft-office-file-712429

 

[Slape]

I tried that already.

I was able to get a previous version from my recycle bin. Whenever the computer is shut down without saving an Excel file, when you recover it after starting up Excel and save it, it sends that recovered file to the Recycle bin