ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   COPYING FILES (https://www.excelbanter.com/excel-programming/347312-copying-files.html)

SURESH

COPYING FILES
 
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



Martin Fishlock[_3_]

COPYING FILES
 
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





All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com