Check FileName for specific word and remove

[keith05281967]

Greetings All,

I have a macro that scrubs incoming files. As part of that process I'd like to have it check the file name. 99% of the time the files are prefaced with the word Actionable (ex.) "Actionable.FILENAME_CurrentDate.xlsx"

I'd like the macro to check for "Actionable." if found, remove it and preserve the rest of the file name.

That being said, each FILENAME is unique so I can't hard code it to say "always rename file to "FILENAME".

Is that possible?

thanks,
Keith

Excel '07

 

[Ruddles]

filename=replace(filename,"Actionable.","")

 

[keith05281967]

thank you Ruddles