save workbook in vba

Question

I tested below codes but didn’t work:

Sub saveMyFile()
ThisWorkbook.Save
End sub

Sub saveMyFile()
Application.ThisWorkbook.Save
End sub

When I try to close application that asked me about save or not.

Answer 1

https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.beforeclose

Answer 2

rodwynnejones thank you,
But i would like to call it from other modules and dont want to add any code to Thisworkbook