I seem to have figured it out! Thank you for your help! My issue with wildcard was that If fn = FilenameExisting doesn't work with wildcards because it's looking for an exactly identical value. What fixed it was If fn Like FilenameExisting Here's the working code. Still plenty of testing to be done ...

Here's where I'm at now. My issue is the wildcards I think. Because files have a date after the name and I don't want to check every possible combination I'm trying to implement a wildcard system after the base name. It also doesn't move the "old" existing file from pdf to archive. Either ...

Not a solution but just an idea. The save as command queries the existing same name and opens a window to save it to a different location if it exists. Maybe. Might be worth exploring but since the "new" file would have a different name (New date & [possibly but not necessarily with i...

Hi y'all, I'm trying to add a new function to a macro we're currently using at work. Currently, if used on a drawing, it takes information on a Userform (Revision, Date, etc.) and creates a filename with it then saves it as a PDF in a subfolder named "PDF". What I'm trying to accomplish is...