I would like to batch append Excel files in a folder. Each Excel file has multiple tabs. I only want to import and append certain tabs...e.g. tabs named "abc" from each workbook file in the folder
How do I do this ?
Currently in the batch append source block I can only batch append based on names of Excel files rather then the name of the tab? Or can I specify the name of the file and the name of the tab as a extension somehow to overcome this?