How can I tell, using VBA, if an Excel workbook has ever been saved?
I want to know if clicking save will save the document to an existing location or prompt me to choose a save location.
If ActiveWorkbook.Path = vbNullString Then
'actions if the active workbook hasn't been saved yet go here
Else
'....
End If
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With