I’ll preface this by noting that I’ve only used the software for a little under four days so I apologize if this is a stupid question. I’ve been working to try to build a bot that consolidates multiple excel files by creating a new file with the input files becoming the sheets. Ideally I am trying to build this workflow in a manner that will continue to work with large numbers of input files (anywhere from 10-100). Although I’ve got a rough format built out: Excel Consolidation Bot.xaml (26.7 KB) I have consistently been getting errors with the “Write Range” activity once all the files have gone through the loop. I’m hoping to figure out how to get that particular activity to create a new sheet on the results workbook for each input file.
I’d be happy to answer any additional questions!