I want to use the dynamic tool to input an xls file that has different sheet names daily. The option i used to use had me type the sheet name to the Full name to get the dynamic tool to read the file and the sheet, however it doesnt work if the sheet name change often. Please help thanks
Are you talking about .xlsx or .xls? .xls requires using R or Python. .xlsx you would use a batch macro with an input data tool. The Dynamic Input tool will not work with schematically different sheets.
You haven't posted if you had solved your problem. I took the liberty of creating a workflow that converts an XLS to XLSX and reads all tables. For you to run the workflow you will need to find where Office has stored the excelcnv executable.