XLSB Macro to read data

ecotton

Hello!

I have a report where I need to pull in the most recent xlsb file from a folder and then read the data. I have done this many times with xlsx file but not for xlsb. This xlsb has multiple tabs to I need to be able to define which tab I use as well. Here is my start. Thanks in advance!

BobR

If you know which tab it is you could use the formula tool to add the sheet name. So something like

[FullPath] + '|||sheet_name'

This will change something like "c:\some\path\some_file.xlsb" to c:\some\path\some_file.xlsb|||sheet_name"

And then feed that into dynamic input.

If you don't know the sheet name you can use that technique to get the list of sheet names. Figure out which one you need. And then add that to the [FullPath] back to dynamic input.

Bob