This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
They are all named the same. All column names are the same. I get the error if 1 or many files are in the directory. I can set the macro to any of them and it outputs correctly. Right now I only have the file referenced in the macro in the directory and it still fails.