Help on Auto save after rimmediately after opening the file

[mhemat]

how can i autosave an xlms file right after opening the file and not before closing. I have the code below that helps with auto save before closing, but it does not work when I want the file to be saved as. The reason for my madness is that my file has auto numbering and saveAs does not let the auto numbering code to work. Do i make sense?

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

Thanks a bunch

 

[daverunt]

I don't understand what you are trying to do but try the Workbook Open event instead.
This won't work until/unless macros are enabled though.

Private Sub Workbook_Open()
ThisWorkbook.Save
End Sub

 

[Smitty]

Please stick to your Original Post.