Watched Folder 1

[Shfog]

How can I 'watch' a folder to move a file with a name that will vary from day to day?
The customer uploads a file to our server with the name "mmdd(cyclenumber)", where cycle number varies with no pattern.
I've got a timer that runs a stored procedure every few minutes to see if a file has been uploaded, but I don't know how to make the file name variable like:

Name "F:\upload\" & Format(Now, "mmdd&quot & "*.zip" As "G:\Newfile"

How do I get the wildcard to work?

Thanks

 

[DrJavaJoe]

'Make a reference to Microsoft Scripting Runtime then do this

Dim fso As New FileSystemObject
On Error Resume Next
fso.MoveFile "F:\upload\" & Format(Now, "mmdd&quot & "*.zip", "G:\NewFolder\"

 

[Shfog]

Works like a charm....

Thanks