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.
That macro should be able to search through the whole C:\ drive find only the XLSX files open it and save it in .xlsb file format in the same folder with the same name by also retaining the original .xlsx file.
As always any direction on this would be great.
Thank you in advance!
Regards
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.
That macro should be able to search through the whole C:\ drive find only the XLSX files open it and save it in .xlsb file format in the same folder with the same name by also retaining the original .xlsx file.
As always any direction on this would be great.
Thank you in advance!
Regards
