Hi All - I am working through a bit where I need to process a bunch of Excel files in a given Directory. I’ve Followed the advice offered here: Loop through a folder filled with excel files and Vlookup to a main spreadsheet
I can’t get this working in my scenario, the sequence just hangs, and never times out. NOTE - there are only 3 files in the directory I’m testing, max 2-3 tabs per sheet.
What I created was the following:
- Assign a variable to the file directory
- For Each File in the directory - Find the Excel Files
- Excel Application Scope - Output workbook “wb” in order to use in the next step to dynamically get the sheet name
- Message with the name of the sheet. (At the moment for testing, ultimately the next steps would be to read/write range from the first sheet of each workbook.) Right now I just want to make sure the looping is working.
I made sure the sheet names step is outside of the wb Excel application scope per forum posts I found. What am I missing here?
Here’s what the sequence looks like: