How to read List of Sheet Names in an EXCEL BINARY (.XLSB) file?

[caltang]

As per the title - how does one read List of Sheet Names from EXCEL BINARY (.XLSB) file?

I cannot upload binary files...

[mceleavey · Accepted 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.

[caltang]

Thanks @mceleavey !

[mceleavey]