Search filename containing words

[Guest]

Here is the thing. I have file that has to be formatted. The file is updated
occasionally because its companys pricelist. So, the name of the file will
change. The fact is that the words "Price list" is always in the name. I want
to make a search that finds the file and changes the name only to be a
"pricelist". What is the code for this?

 

[Bob Phillips]

Sam,

Take a look at the Dir method in VBA help. It allows selecting partial
names. Although how you will manage if there are two, I do not know.

--

HTH

RP
(remove nothere from the email address if mailing direct)