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!
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
I know which tab I need to pull but the xlsb will constantly change. There is a new xlsb added each day and I need that new one. That is why I am pulling the most recent file.
The solution above will work then. Just add "|||sheet_name" on the end.
Bob
Sorry, I have not worked with the dynamic input enough. Could you please tell me what I am doing wrong? Thanks!
Select "Change Entire File Path"