I followed the instructions on the below blog and was able to get most of my sheets to pull in from my excel file. The problem is that it will not pull in my tabs that have spaces and gives me the error message listed in the attachment. Any ideas what I add to the macro to get this to work?
https://www.concentra.co.uk/blog/how-import-multiple-excel-sheets-and-files-different-schemas-alteryx
Hi,
Looks like the first CrossTab Tool was changing 'special' characters to underscores.
How about this as a replacement?
Your macro worked for me using with various worksheet names including/excluding spaces etc. Can you provide a sample of data from Test Database.xlsx so that I can test against the original flow?
Cheers,
Iain
Sorry about that, attached the wrong file. Here is the excel file.
