Dim SourceFile, DestinationFile
SourceFile = "D:\myFile.xls" ' Define source file name.
DestinationFile = "D:\Dar\myFile.xls" ' Define target file name.
FileCopy SourceFile, DestinationFile ' Copy source to target.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roger" wrote in message
...
please give example of code to copy a file called Update.xls from my CD "D
drive" to C:\Dar\
--
Roger