VBA code to message box if filename already exists then prevent save

[Elliott_the_noob]

Hello all,

I have the following code to automatically save a backup copy of the workbook to a designated folder with the filename as what appears in cell n43 however I need it to display a message indicating that the filename already exists, then if so prevent the user from saving. The code works no problem right now but it will save over the backup copy without warning.

Thanks in advance!

Please Login or Register  to view this content.

[Bernie Deitrick]

Please Login or Register  to view this content.