Hello all,
I recently discovered the benefits to converting Excel documents to XLSB (binary), mostly the cutting almost in half of file sizes.
I would like to apply this to some of my older files, but don't want to sit around resaving these documents.
Does anyone have a code that will open all XLSX/XLSM/XLS and save a new copy as XLSB. I would like to retain the original file for the time being as a backup to see what type of if any corruption issues will occur. This will be done in one of three paths:
I imagine the path will obviously need to be changed depending on the scenerio. I would like the XLSB version to be saved in the same area as the XLSX/XLSM/XLS document.
As always any direction on this would be great.
Thank you in advance!
Regards,
Hollando
I recently discovered the benefits to converting Excel documents to XLSB (binary), mostly the cutting almost in half of file sizes.
I would like to apply this to some of my older files, but don't want to sit around resaving these documents.
Does anyone have a code that will open all XLSX/XLSM/XLS and save a new copy as XLSB. I would like to retain the original file for the time being as a backup to see what type of if any corruption issues will occur. This will be done in one of three paths:
- Desktop
- Folder within Documents
- Shared Drive
I imagine the path will obviously need to be changed depending on the scenerio. I would like the XLSB version to be saved in the same area as the XLSX/XLSM/XLS document.
As always any direction on this would be great.
Thank you in advance!
Regards,
Hollando
