how to move multiple files with same extension

[stever1725]

I have written some code that imports all .xls files from C:\Import .... into access... creates a report that gets sent to management. Can anybody help me to now move these files from C:\Import... to C:\Import\Processed ?? i have tried quite a few different codes but cannot get them to move. any help would be appreciated. thanks steve

 

[PHV]

A starting point:

strFileName = "somename.xls"
Name "C:\Import\" & strFileName As "C:\Import\Processed\" & strFileName

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[stever1725]

PHV, thanks for the pointer... i got it hammered out... i even got it to where it adds the date to each file. much thanks.

 

[lameid]

If you have not already done so, I suggest you move your files as you import them one at a time. This will prevent a file created mid process incorrectly being moved.