I’m automating a process where we have a selection of accounts (25-30) listed in Excel. We take each account, look it up in a web-based system, take a screenshot of the information (.png) and download supporting documentation (.xlsx/.csv). I have it completed to the point of downloading all the necessary files and taken all screenshots. Each file is named for the account that was looked up, so if there is account “12345”, then a supporting document would be 12345_Doc.xlsx.
My next step that I can’t figure out is taking those files (.png, .xlsx, .csv) and attaching them back to the Excel sheet where the selections were based out of. Ideally, I’d be able to create a tab for each account and attach all files with the account in the file name.
I’ve tried using a “For Each Row in DataTable” (which is how the files were downloaded) and couldn’t get it to recognize separate tabs.
Using “For Each File in Folder” it was making a tab for each file, which may be overkill because I’d end up with 120 tabs that I’d have to figure out how to consolidate.
Has anyone done anything like this?