G
Guest
Hi all,
I use the following to copy a file to my comp:
'----------------------
Dim SourceFile, DestinationFile
SourceFile = "S:\Backups\HS0731.DBF"
DestinationFile = "C:\Backups\HSLast.DBF"
FileCopy SourceFile, DestinationFile
'----------------------
My issue is that I want to change the SourceFile to the last file of
previous month.
For e.g: This month is August, and the last file created in previous month
was HS0728.DBF, then the SourceFile should change to "S:\Backups\HS0728.DBF".
Any ideas ?
Thanks in advance.
I use the following to copy a file to my comp:
'----------------------
Dim SourceFile, DestinationFile
SourceFile = "S:\Backups\HS0731.DBF"
DestinationFile = "C:\Backups\HSLast.DBF"
FileCopy SourceFile, DestinationFile
'----------------------
My issue is that I want to change the SourceFile to the last file of
previous month.
For e.g: This month is August, and the last file created in previous month
was HS0728.DBF, then the SourceFile should change to "S:\Backups\HS0728.DBF".
Any ideas ?
Thanks in advance.