I am trying to read an Excel file into a data table.
I use the output data table and then message box to check if the data table is being read correctly.
When I specify “” in the Range to be read, the message box does not pop up.
When I specify a certain range eg. “A1:U10” then the message box would pop up (and the data table is being read correctly) - but I want the automation to be versatile to be able to pick up all the data in the sheet.
What’s the reason for this?
Thank you in advance for your help!