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

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