As per the title - how does one read List of Sheet Names from EXCEL BINARY (.XLSB) file?
I cannot upload binary files...
Solved! Go to Solution.
Hi @caltang ,
xlsb is not a supported format so you can use a converter script in .vbs to convert from .xlsb to xlsx, and then you can use the in-built functionality to read the sheet names.
Check out THIS thread on how to do this. This is converting from .xlsm but you can change it accordingly as the concept should be the same.
I hope this helps,
M.
Thanks @mceleavey !