VBA Editor doesn't warn about unsaved changes on exit

[JenniferMurphy]

I thought I had made some changes to a UDF, but when I opened up the VBA editor today, the changes were gone. So I ran a little test. I made a simple change to some code, then closed the editor and then Excel. I did not get any warn about unsaved changes or any offer to save them. When I restarted Excel and reopened the editor, the changes were gone.

Is this normal? Do I have some setting wrong?

 

[JenniferMurphy]

No it’s a manual save routine that I run after making changes.

Oh, OK.

Microsoft don’t care about VBA. It’s clearly not part of their vision for the future.

That means that they don't care about their customers, which means they don't care about me.

And this must have been the case since VBA was first released. Was it not part of their future then? Jerks.

 

[shg]

For Personal in particular, I use this, because it both saves and creates a backup (I have been known to hose stuff with the best of intentions):

Sub BackupPersonal()
  Const sBak        As String = "C:\Users\shg\Documents\Docs - shg\Tech Notes\misc - Templates\Personal.xls."

  Application.DisplayAlerts = False
  With Workbooks("Personal.xls")
    .SaveCopyAs sBak & Format(Now(), "yyyy-mmdd-hhmm.bak")
    .Save
  End With
  Application.DisplayAlerts = True
End Sub

You still need to remember to run it.

 

[JenniferMurphy]

For Personal in particular, I use this, because it both saves and creates a backup (I have been known to hose stuff with the best of intentions):

Sub BackupPersonal()
  Const sBak        As String = "C:\Users\shg\Documents\Docs - shg\Tech Notes\misc - Templates\Personal.xls."

  Application.DisplayAlerts = False
  With Workbooks("Personal.xls")
    .SaveCopyAs sBak & Format(Now(), "yyyy-mmdd-hhmm.bak")
    .Save
  End With
  Application.DisplayAlerts = True
End Sub

You still need to remember to run it.

That's helpful, thanks. I take backups all the time, especially just before making anything other than trivial changes. (I bet I've hosed way more code than you have.)

I consider this behavior by M$FT to be grossly negligent and arrogant. This is just horrible corporate behavior. Sadly, it's not rare. Woody Leonhard documented 500-600 pages of total screw-ups in various versions of Word. MAny have not been fixed to this day. Is Word also not in their future plans? (One wasn't enough.)