View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ebferro ebferro is offline
external usenet poster
 
Posts: 4
Default Move file to a different folder

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

"E Oveson" wrote:

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

"ebferro" wrote in message
...
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.