Search through excel files in folders then copy them to another folder


I want to search through excel files in a folder then copy them else where.


May I know what error are you getting here ?

Hi @sparkplug93

Please add [for each row] for get data in your datatable
and try to use follwing condition


See as below for guideline

I hope it would be useful for you :blush:

I’m getting an error at output tables (variable type DataTable) and with the condition for the if statement. Additionally, is there a way to move these files to a folder if they contain the keyword?


If you want to search anywhere in that excel THEN
Read Range-----dt1
output datatable—textdt
yes then Move/Copy

No objects are being moved but I’m not getting an error. Any ideas?

Will you pls share the values that are used in filename and copy??
if possible share your xaml

ExcelDocSearch.xaml (10.1 KB)

Do you want to check North keyword in entire excel ryt?
if yes then You can directly use LookUp Range so if that matches the keyword then
ExcelDocSearch.xaml (13.6 KB)

or if you want to search for each row then
ExcelDocSearch.xaml (10.4 KB)

Neither are working. But the first one worked much quicker.

Hope u get the idea make changes as per your need
Happy Automaion

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.