Can I find a string within a file name and delete that string in VBA?
I am working within a quality system, and I work off of a redlined document (microsoft word). When I go to upload it into our system, I need to upload the redlined version (it says “redlines” in the filename), and then a clean copy and a pdf copy. I have recorded a macro that does everything except changing the file name. Is it possible to search for the word “redlines” in the file name, delete that word, then save it as a new file? This is what I have so far. For example, if my redlined version is called “My File Redlines.docx” I would want it to save the file as “My File.docx”. The filename can vary in length, and the location of the word “redlines” can also vary, so it can’t be based upon a fixed location.