Good day all.
I seem to be having a trial making this issue easy and productive for the users. First, I have a macro on the LEAD file and will open an ESTIMATING template. The name of the LEAD file is inserted within the ESTIMATE.
When a button is clicked in the ESTIMATE template, it will save within the same folder as the LEAD file...and actually two folders deeper which is perfect.
I currently have the macro set so that the ESTIMATE template saves with the same name as the LEAD folder but adding 'EST' on the end. That's fine. Then if the button is clicked again from the template, it will add a 2 tot he file name, then a 3, etc.
Here's the code --
Is there any way I could change this so if a file already exists, a popup will ask if the user wants to save it as another file name instead of just adding the 2 or 3 on the end?