New to this forum, I hope I get the syntax right! I created a UserForm which has a command button that will take 2 sheets of my large workbook and export them as a single PDF. Here is the code:
The problem is, things get really hairy when a user exports this a second time. The sheets contain information that will update need to be exported multiple times, but at best this overwrites the old file (not ideal), at worst if the old file is open it crashes. I'm not sure if there's a way to make the filename variable, or if there's another command I can use to export without saving and allow my users to save as they wish.