Thread: Moving Files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PraxisPete PraxisPete is offline
external usenet poster
 
Posts: 25
Default Moving Files

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