I am wondering if anyone has tried to do the above? I can’t seem to figure out how to get the bot to read a specific cell from an Excel, if what is in the Excel matches with the name of the file in a directory, move that file into another folder.
For more details, I have an excel file and in Column H, it has the file names. Example: Test1.pdf in Cell H1, Test2.pdf in Cell H2, Test3.pdf in Cell H3. I have a directory that contains these PDFs (Test1, Test2, Test3). Let’s say they are in U:\Files. There is a another folder in that directory called “Other Folder.” (U:\Files\Other Folder). I want the bot to be able to read each row on the excel, and if the cell matches the file name in the directory, it gets moved to the “Other Folder”.
Any input would be nice! Thank you!