hi there
i use this code to copy a file from a source folder to the destination folder.
[Mylistbox] is a list in the form where the file name apears.
I want when the file is copied to add the current date to the file name
for example, if the file name in the source folder is "test.doc" in the destination must be "test10-01-2006.doc"
please help me
thanx...
i use this code to copy a file from a source folder to the destination folder.
Code:
Dim myfolder$, myfoldertarget
myfolder = "C:\source\"
myfoldertarget = "c:\target\"
Dim fs As Object
Set fs = CreateObject("scripting.filesystemobject")
fs.CopyFile (myfolder) & [mylistbox], [myfoldertarget], True
[Mylistbox] is a list in the form where the file name apears.
I want when the file is copied to add the current date to the file name
for example, if the file name in the source folder is "test.doc" in the destination must be "test10-01-2006.doc"
please help me
thanx...