Search all excel files in folder for keyword, then if they have the key word move to a different folder

Help
21

I’m not getting an error, the documents are not moving to the new folder. Thanks for your help

22

can i have a view on the xaml if possible
@sparkplug93

1 Like
23

ExcelDocSearch.xaml (5.1 KB)

1 Like
24

Hi,

Check with this,

ExcelDocSearch.xaml (5.3 KB)

25

Thanks! Is there a way to search in the files rather than just the names?

26

we can do that if it is a text file or a html file where the content can be searched directly. But this is excel file, so you need to read the file individually before search inside the file content.

1 Like
27

How would that be done? Thanks for your time

28

Yah of course
make sure we have like this

image
image974×413 22.7 KB

Cheers @sparkplug93

1 Like
29

ExcelDocSearch.xaml (6.5 KB)

Check this to search inside the content of files in a directory

1 Like
30

I’m still encountering the same issue where no files are moving. I added my search criteria and correct folders.

31

but why your marked something as a solution then? :stuck_out_tongue_closed_eyes:

32

My mistake haha

33

if you want to search inside excel files, use LookUp Range…

34

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