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
|