Importing 2 Excel Files to Render 2 Separate tabs in 1 Workflow

[sakowsda]

Hello - I am looking to import two Excel files that are identical in layout (just different data in each file) so that they appear as two separate tabs in my one workflow. Ideally it would look like File 1 > "1235 JE" tab and File 2 > "1960 JE" tab. I do not need to alter these tabs at all - I just simply need to bring them in. Is there a way to do that? Thanks!

[griffinwelsh]

@sakowsda if I understand the ask correctly you can use this macro along with a directory tool pointed at the source of your excel files. Use the fullpath of your files as the control parameter that you feed into the macro. The macro will give you a field that indicates which spreadsheet each record came from.