Get a unconsolidated file in separate output.

dkma

Hello all, 

I created an app. to consolidate all the excel file from a folder.  

Stucture would be

1 .  App

2. macro to find specific sheets

3. to make calcluations based on sheets. 

99% of files will have the datasets in the same format. if any file has a different format, the app is throwing an error. 

i wanted to report that excel file name in a separate report template as an output. 

Any body has any workaround. It would be highly appreciated.

Thanks!

patrick_mcauliffe

What have you tried so far?

I would just make sure that your input tools all have the option set to include the file name.  You can parse out the sheet name from that, sinc.e an Input with Excel shows the sheet name at the end of the filename.

Then just use a Summarize/Group By tool and add another macro output.