Copying files with certain name from a list (excel)

[danhvoqq]

Hi everyone,

I am pretty new to AutoIT, I am looking for a solution to help me in my daily work.

Daily, i have an Excel file which contains a list of names in one column, and i have a folder which also contains the files. My job is to copy the file in one folder to another folder (copying by the name from the list in the Excel file).

For example:

In the excel file, i have a column with all the values: ABC, AB_X, 123_ABC, etc. I will open the folder, searching for the file with the name above and copy the file to another folder.

 

I am wondering if there is anyone have done anything like this before. Please share with me.  Thank you!!!!

 

 

[caramen]

Hello,

I doubt you gonna get a code poping like that for you into the forum 

Here we are working to help on the issue from your own code. We won't code for you. 

 

You could make a try on something and if it does not work then you come with your issue.  And post your code.

 

Look into my signature. Water's UDF to read Excel. 

You will need a bit of regular expression maybe depending on how you will process. 

You could also look the function : DirCopy / FileCopy

Edited October 25, 2020 by caramen

[sudeepjd]

Looks easy enough. Check out the below help topics to get you started.

• _Excel_Open to open the Excel - https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_Open.htm
• _Excel_BookOpen to open the workbook - https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_BookOpen.htm
• _Excel_RangeRead to read the range and put it into an array - https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_RangeRead.htm
• For...Next to Loop through the array - https://www.autoitscript.com/autoit3/docs/keywords/For.htm
• FileCopy to Copy the file - https://www.autoitscript.com/autoit3/docs/functions/FileCopy.htm
• _Excel_BookClose the Excel book - https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_BookClose.htm
• _Excel_Close - Close Excel - https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_Close.htm

 

Actually I just seem to have written the code for you using the exact steps you need and the help files to read through to get there. If you still have a problem post the code that you have tried and will try and help.

All the Best.

Sudeep.

Edited October 25, 2020 by sudeepjd

[danhvoqq]

Hello sudeepjd & caramen,

Thank for your reply and great advise! This is exactly what i am looking forward.

Now, i will try to make my own code, and come back later if i have any more question.

Thanks again!