Corrupted Excel xlsb (binary) file

DEksel

Board Regular
Joined
Oct 5, 2019
Messages
52
Actually, subject. Any medicine for this? Need only VBA of course...

Blocking excel with tough resource eating... can't open and can't see anything... Office 2016, Windows 10.

Thanks in advance.
 
I'm very familiar with the XLSB file format, and it's speed benefits. Of course, this also works against it - because if it were an XLSM file, you might have been able to extract the VBAProject.bin file (which houses the VBA code).

XLSB files are (sometimes) generated by Excel for documents that are open when it crashes - which is why asked, and why I also asked that - if that were the case - what was the original file type... Because when you load a workbook that you then "can't see" (as you described), my immediate thought is that it is an XLAM file for example. That obviously is not the case here though.

Sorry that you weren't able to resolve it, though. I hope that you didn't lose any important code.
XLSB file does not need to have any other file as source. That is common format as CSV, XLS, XLSX, XLSM... the diff with XLSM is that XLSB file is 'compiled' while XLSM you can open with ZIP tricks etc...

I've posted above the link of tough guys who can save (exctract) your Worksheets and that is very nice. About coding -- BAS copies are always welcome of course...
 
Upvote 0

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top