<div>
Thank you very much for the quick response. &nbsp;This worked very well. &nbsp;I made a slight adjustment to delete the source file and it does exactly what I needed.<br />
<br />
oFS.DeleteFile (&quot;C:\sourcepath\&quot; &amp;&nbsp;file.name)<br />
<br />
Thanks again!
</div>


Thank you very much for the quick response.  This worked very well.  I made a slight adjustment to delete the source file and it does exactly what I needed.

oFS.DeleteFile ("C:\sourcepath\" & file.name)

Thanks again!

<div>
<div class="content wysiwyg-content">
I have a repetitive task each month to move files from one location to another based on the file name. &nbsp;In this case, we have a PDF file that has a name of a person. &nbsp;Example: Doe, John (1234).pdf <br />
I would like to create an Excel list that has two columns. &nbsp;The first column would have the name of the destination folder and the second column would have the name of the file. &nbsp;The name of the file never changes, only the content of the file for that user. &nbsp;There are about 200 files that will be moved during each session.<br />
Column A = Folder name- JohnD<br />
Column B = File name- Doe, John (1234).pdf<br />
<br />
I would like to find a script that will loop through each file in the origin folder<br />
Get the file name<br />
Lookup the file name in the Excel list<br />
If the file name is found, get the destination path/folder from the matching column<br />
Move the found file to the destination folder<br />
Overwrite the file in the destination if it exists<br />
Delete the original file<br />
<br />
Any suggestions?<br />

</div>
</div>


I have a repetitive task each month to move files from one location to another based on the file name.  In this case, we have a PDF file that has a name of a person.  Example: Doe, John (1234).pdf 
I would like to create an Excel list that has two columns.  The first column would have the name of the destination folder and the second column would have the name of the file.  The name of the file never changes, only the content of the file for that user.  There are about 200 files that will be moved during each session.
Column A = Folder name- JohnD
Column B = File name- Doe, John (1234).pdf

I would like to find a script that will loop through each file in the origin folder
Get the file name
Lookup the file name in the Excel list
If the file name is found, get the destination path/folder from the matching column
Move the found file to the destination folder
Overwrite the file in the destination if it exists
Delete the original file

Any suggestions?


Move files based on an Excel list

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.