Macro to Save file as PDF with Error to stop if name already exists

[jan mason]

Hi,

Please could someone help with the attached excel form I have created. I have the VBA Code to save the form as a PDF using cell C5 as the reference cell. The code works apart from the error, it keeps re-saving over the original file. Could someone tell me how I add the date and time into cell C5 so that it becomes unique everytime and then the error code isn't required. I have tried Concatenating Cell C2 into C5, but this generates a huge number. I would like the name to still be readable. Or if someone can look at the code and tell me how I get the error code working, so that if the name exists already the VBA code adds "_1" onto the end then "_2" etc.

Thank you in advance for your help