I have to look through a particular network folder to find a file then copy it to another network share.  I have the format of the file name, but I need to do a wildcard search through the folder to get the complete filename before I can use

"filecopy sourcefile, destinationfile"

What is the code for finding a file that lets me use wildcards?

Thanks,

Don't know about FileCopy but the File System Object would do the trick.

Private Sub Command1_Click()
Dim fso As FileSystemObject
Set fso = New FileSystemObject
fso.CopyFile "C:\*.mdb", "C:\Testit\"
MsgBox "Done!", vbInformation
End Sub

FileCopy copies a file to an other folder.

FileCopy "C:\Windows\Calc.exe, "C:\Temp\Calc.exe"

He was asking how to find a file.

http://www.martin2k.co.uk/forums/

Quite an oversite.    Should have read the whole post.

Look up the DIR function in VB help and it will give you a good example of using wildcards.

http://www.martin2k.co.uk/forums/

You're both right.  I was asking about finding a filename using wildcards so I could use the filecopy the way I outlined it in the original post.  However, I was also open to any other ways of accomplishing the same task.

I seems so simple a task, I thought it was just my VB rust getting in the way.

How would I go about doing a wildcard search for a filename then copying the file I found to another network location?

I don't appear to have access in my program to filesystemobjects or the methods for them, if that's the right terminology.

Thanks

Add a reference to Microsoft Scripting Runtime.  You might also want to look into the API for finding your files as it is faster.  Here is an example using the FSO:

http://www.freevbcode.com/ShowCode.Asp?ID=5510