I use this approach all the time. But today, it will not work.
The directory tool and the macro's input tool are set to the same directory. The directory contains Excel files. Running the macro outputs the correct table. But, the workflow fails with the error "No table chosen, please select a table from data source." This occurs even when I remove all files except for the one referenced in the macro.
Within the macro... the file path is set to the same directory found used in the workflow's directory input tool; file format is set to Microsoft Excel (*.xlsx); Table is set to the correct table name; and output file name as field is set to full path.
What am I missing??????
Thanks.
I
