I'm creating a workflow that uses a directory input to find all .xlsx files in a folder and outputs the filenames to a standard macro. The standard macro updates the input FullPath, identifies the start data import line number, and outputs the FullPath and start data import line number to a batch macro. The batch macro should take the datastream from the standard macro to use the FullPath to update the input FullPath and use the line number to update the input data import line number before running through a few other actions.
The files in the directory input are mostly the same, but some have fields that others don't and the number of header rows varies among the files. I've tried what feels like a hundred combinations of input parameters and actions, and I still can't get the batch macro to use the input parameters I need it to use. Please help!
Samples of the files contained in the Reports directory are included, along with the workflow package.
