Excel VBA Script to Move files from one folder to another based on data in three columns

I need help with creating a script that will take the data from an excel file and use it to transfer files from one folder to another.

Column A will be the current directory
Column B will be the File name
Column C will be the new directory

There will be 10,000+ rows.

Please Login or Register  to view this content.

I think, it's a while since I've written that sort of code.

Assumes your directory includes the "\" at the end and that your filename includes the extension and that the destination folder exists.

It is giving me an error that "File already exists", but the destination folder (Column C) is empty.

Donne

try:

Please Login or Register  to view this content.

instead

It says "syntax error"

Sorry about this, will get there in the end:

Please Login or Register  to view this content.

It says Runtime Error 58 - File Already Exists

Pretty sure the file you are trying to move already exists then...
Can you upload a workbook with an example of the data in A, B and C columns, click go advanced and then attachments.

I have attached the Excel file.

I tried this on your example data and it worked ok:

Please Login or Register  to view this content.

Perfect. Thank you so much!

Can I use similar logic to rename a file?

to rename a file you would need:
fs.getfile("C:\example.xls").name = "C:\renamedexample.xls"