vba wildcard - FileCopy

[p4nny]

Hi

I'm using the FileCopy function to copy files from one location to another.

I would like to change slightly so that I can use a wildcard

For example:

\\homedrivestmp\homedisk1\saery\Desktop\test250118.xlsx

Rather than specify the file name as above, I would like to target files where the file name is 'like' "test"&??0118

is this possible?

Many thanks

 

[Domenic]

Try using the FileSystemObject instead. Here's an example...

Sub test()

    Dim fso As Object
    
    Set fso = CreateObject("Scripting.FileSystemObject")


    fso.CopyFile "c:\users\domenic\documents\test??0118.xlsx", "c:\users\domenic\desktop"
 
    Set fso = Nothing


End Sub

Hope this helps!

 

[p4nny]

Works great thank you,

How would I wildcard the word "test" as it could be test, test1, test2, test3, test10, test100 etc

 

[Domenic]

That's great, glad I could help. For your subsequent question, try...

fso.CopyFile "c:\users\domenic\documents\test*.xlsx", "c:\users\domenic\desktop"

If you want to add it to your previous criteria, try...

fso.CopyFile "c:\users\domenic\documents\test*??0118.xlsx", "c:\users\domenic\desktop"

Hope this helps!

 

[p4nny]

Hi

I have a filename as follows: "IT COS 120118"

How would I find amend so to find files with the filename like "IT" *ignoring the rest of the filename

Much Appreciated

 

[p4nny]

Now resolved thanks anyway