Stop overwrite of file if it already exists, no popup wanted

I can get rid of the popup/warning about overwriting an existing file, but I just can't figure out how to get the macro NOT to overwrite the file if it already exists. A coworker ended up deleting a couple days worth of data entry the beginning of this month, so it was no big deal at that time (barely an hours worth of work this time), but I want to prevent a complete loss of the month if they decide to do it again later.

I've included the entire code below, but have highlighted the coding I'm working with in red below. So long as I leave out the red coding, the popup comes up, but nobody reads it, so the file gets overwritten

Thanks in advance for your help

Please Login or Register  to view this content.

Hi, LoneWolf3574,

have you tried using Dir and deciding on the length of the string prior to saving if to or not save?

Ciao,
Holger

Hi, LoneWolf3574,

in your code you use

Please Login or Register  to view this content.

What I meant was to wrap this one line of code in an If-Statement and only save if no workbook with that name is present like

Please Login or Register  to view this content.

which may lead to the following code also being dragged into the If-Statement.

And you could cut down

Please Login or Register  to view this content.

to either

Please Login or Register  to view this content.

or even shorter to

Please Login or Register  to view this content.

Ciao,
Holger