I am inputting a directory of multiple files from a folder location where I want to perform a series of steps for each file seperately and then union the data back together again. Can this be done with either an interative or batch macro? But some of the headers of the data will differ for each file pulled in and in the macro i would be using the dynamic rename so I would want all of the headers across all the files to be put on the top header.
Any ideas how to do this?
Solved! Go to Solution.
This Knowledge Base article should help:
The Ultimate Input Data Flowchart
Chris