Check for user save in Excel

[jmnekrkt]

I have a workbook with a submit button. When the user clicks submit, I want to see if the fill has been saved with a new name. If not, I want to display the Excel Save dialog box...after the save, the macro sends an email w/the file attached. I currently have working code that asks the user for a file name and then has them select a directory to save and use the combo of the two to do a saveas...I don't want to use that routine if the user has already saved the file in the location of their choice.


Thank you

 

[TonyJollans]

Hi jmnekrkt,

Just check ActiveWorkbook.Saved. True if saved, False if changed since saving.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.