Wild Card in VBA

[aclare]

I have a weird situation. I use a macro to grab a set of 4 reports and attach them to an e-mail tied to a specific e-mail address. The system that generates the report started saving a random number to the end of the file, so they are:

Fund Report_12345.xls
Fund Report_02958.xls

Is there a way in either excel or VBA to have a wild card (i.e. Fund Report_*.xls) so that the file will get picked up even if I don't know the random number?

 

[CharlesChuckieCharles]

Short answer is Yes

You sort of answered it yourself : Fund Report_*.xls

But with out knowing how you attached the files before difficult to help any further

 

[aclare]

Short answer is Yes

You sort of answered it yourself : Fund Report_*.xls

But with out knowing how you attached the files before difficult to help any further

Do I put the wild card in VBA? I tried:

 oldname = Range("A" & i).Value & "*" & Range("B" & i).Value

in cell A1, I have: Fund Report
in cell B1, I have: .xls

It doesn't seem to be working as it thinks the file name is now FundReport*.xls.

 

[aclare]

Nevermind... I figured it out... for everyone's benefit, this is what I used:

 oldname = Dir("C:\" & Range("A" & i).Value & "_*" & Range("B" & i).Value)

This finds a file name in the C:\ directory with a wild card