having 2 conditions with Replace Function

[keith05281967]

Greetings,

I'm using a Replace function ***in vba code*** to remove a word from a file name and it works perfectly. Can I have 2 conditions in a Replace function?

currently:
sFile = Replace(sFile, "Bob.", "")

below is my attempt to add a second condition....vbe didn't like my syntax.

sFile = Replace(sFile, "Bob.", "") Or Replace(sFile, "Bob_", "")

Sometimes the word to be removed is followed w/ a period and sometimes an underscore, but either way i want to remove it.

excel 07
thanks,
Keith

 

[JackDanIce]

Would this work:

sFile = Replace(sFile, "Bob*", "")

i.e. using a wild card?

 

[keith05281967]

Dan - I just tested it and it doesn't work. I think because there is more to the file name after the . or _

the files look something like "Actionable_FILENAME.xlsx"
or "Actionable.FILENAME.xlsx"

which is why i'm looking for a way to get a second condition in the argument of the Replace function.

Keith