Move file to a different folder

[Guest]

I've got a short vba program that extracts data from a spreadsheet, massages
the data and then puts the data into a comma delimited text file. When I'm
done with the spreadsheet, I'd like to move it from the i:\defective reports\
subdirectory to the i:\defective reports\processed\ subdirectory so that I
don't put the same data into my text file twice. Could anyone show me how to
do this? The spreadsheet file name variable is called SheetFileName.
TIA.

 

[E Oveson]

The simplest way would probably be to just copy it, and then delete it from
original location:

FileCopy "i:\defective reports\" & SheetFileName, "i:\defective
reports\processed\" & SheetFileName
Kill "i:\defective reports\" & SheetFileName

-Erik

 

[Guest]

Erik:
That worked great. Thanks for the help.
Ernie