Hello,
i am working in a workflow and there are multiple inputs files (around 15) and each of these file have single and/or multiple different sheets with different data. How can i create a macro that will help to bring all these file along with sheets name then i can mapped data from these sheets into different places on my workflow(as requirement). i am not combining or piling data from all these different sheets into one. i have found multiple articles and examples but all of these are compiling/piling data from all different sheets into one. For example here i illustrate list of my all input files along with different sheets name
File Name sheet name
ASIA | INDIA |
CHINA | |
EUROPE | UK |
NI | |
AMERICA | USA |
CA | |
AFRICA | EG |
My expectation is how can i get all these sheets name and then also how can i map data from each one of these sheet into my workflow.
INDIA |
CHINA |
UK |
NI |
USA |
CA |
EG |
I also tried with Dynamic input tool without Macro then i got error message "check your path" and/or " file is corrupted"
Solved! Go to Solution.
@Qiu this are not answering my question because i am trying to bring different sheets from different input files.