Dear Suresh,

Why not try the FileSystemObject as shown below.

You can then check the DateCreated property.

Sub ShowFileInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = "Created: " & f.DateCreated
MsgBox s
End Sub



"SURESH" wrote:

dear friends...

i want your help in this regard....

i want to copy some files from B:\ (map drive) to D:\ (local drive)... i
dont want copy only the file which is yesturday modified/or new file.

is there any way in knowledge to fulfill my requirement...

thanks in advance..

suresh tp