Thread: Moving Files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Moving Files

Pete,
Check out FileCopy and Kill.

NickHK

"PraxisPete" wrote in message
...
Hi everybody

I have a workbook that contains a procedure which:

1, Opens a .xls from a SourceDir
2, Alters the contents of this .xls
3, Produces and saves a CSV file to a CSVTargetDir
4, Saves and closes the altered .xls to AnotherTargetDir

Is it possible to move the original .xls file from the SourceDir
to an ArchiveDir ?

Many thanks
PS using Excel 2002