N/A
The only thing you download when you click the button is that you get a file called <files.jpg>no macro here, just an image
Whoops! Thanks for pointing that out, attached the macro image instead of the macro! Lol
Thanks Kevin!
I ran it but I got the Control Parameter must be mapped to a field error?
@Hi2023 If you click on the macro itself, you'll see on the configuration panel on the left that you just have to tell the macro which column of your data has the list of filepath's within it. The macro will batch through this list and read each file. Let me know if you are still having issues!
I am not completely understanding what you mean. This will be able to read multiple files with different columns?
I am trying to join multiple reports and some of the sheets from these reports but the columns are not the same.