Hello!
I am trying to pick up a file that may have extra spaces in the sheet name or be named somewhat different. (for instance it is supposed to be "StringA StringB" but the sender only calls it "StringA" )
I am looking to pick up a file from a directory, then find the sheet LIKE StringA so I can match that to a dynamic input. Is there any way to use the directory tool (or a different tool) to read in the sheet names so i can choose one?
I was thinking i could find the file from a directory tool and use the dynamic input to read the sheetnames then a second one to grab the actual sheet, but I did not see that capability.
Crew macro Excel Wild Card input does not work since there will be multiple files, but I only want the newest one.
Thank you
Solved! Go to Solution.
Thank you!