File input error on .xlsb files when getting the List of Sheets

Is there a way to get the list of sheet names of a .xlsb excel file?

I have been getting the list of sheet names to check if a sheet is missing and this works fine with .xlsx and .xlsm file formats, but not with .xlsb. I have a directory tool, with a wildcard file type, passed on to a formula tool like this

and then passed onto a macro workflow. However, I've been getting an error that says:

Error Opening table: Microsoft Access Database Engine: The Microsoft Access database engine could not find the object '<List of Sheet Names>'. Make sure the object exists and that you spell its name and path name correctly.

Any help or suggestion is greatly appreciated.

Workflow

Input

Error Message

Accepted answers

GiuseppeC

Hi @KMadamba,

in order to read in a .xlsb file you need to install the Microsoft Access Driver, which you can find here: https://www.microsoft.com/en-us/download/details.aspx?id=13255

Unfortunatly, the 'get the list of sheet names' option is only available with a .xlsx file format, not with the binary one (you'll have to select the sheet from the output).

You'll have to pass into the macro the list of full paths, including sheet names (i.e. c:\path\file.xlsb|||Sheet1$, c:\path\file.xlsb|||Sheet2$, ...) in order for it to access all sheets and process the data accordingly.

Hope this helps,

Giuseppe

All comments

GiuseppeC

Hi @KMadamba,

in order to read in a .xlsb file you need to install the Microsoft Access Driver, which you can find here: https://www.microsoft.com/en-us/download/details.aspx?id=13255

Unfortunatly, the 'get the list of sheet names' option is only available with a .xlsx file format, not with the binary one (you'll have to select the sheet from the output).

Hope this helps,

Giuseppe

KMadamba

Thank you @GuiseppeC ! It definitely helped.

Shaaz

Can you please share the sample workflow ??

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703