Unable to save edits to xlam with other file opened

[jcarlosd]

- If I open a .xlam file, I can modify it and save it without a problem (from VB Editor window and File-Save)
- But if I have a regular .xlsx opened too, and go to the VB Editor, the File-Save does not save my .xlam file. If I try (or simply clicking on the save icon) the screen flashes but nothing is saved

I am running Excel 2016 under Windows 10

I went to the forum and found this similar post: https://www.mrexcel.com/forum/excel-questions/485377-unable-save-edits-xlam-2.html
But my problem is lightly different

 

[RoryA]

The save button in the VBE has always been unreliable in my experience. I suggest you add some code to the add-in to save itself, so that you can just run that as and when required.

 

[jcarlosd]

I suggest you add some code to the add-in to save itself, so that you can just run that as and when required.

It's an interesting idea. I tried to write a couple of code lines with that solution:

Sub SaveMyXlam()
Dim VBAProj As VBProject
Set VBAProj = ActiveWorkbook.VBProject
VBAProj.SaveAs VBAProj.Filename
End Sub

However this code returns an error 748. How can I save my current VB project?

 

[RoryA]

You don't save the project, you save the workbook:

Sub SaveMyXlam()
ThisWorkbook.Save
End Sub

 

[jcarlosd]

Thanks RoryA! I was trying with ActiveWorkbook.Save, but the correct one is ThisWorkbook.Save, as you pointed.

I still wonder why Excel 2016 can not perform a simple file save from the VBE, as it was working in versions 2010 and before...

 

[RoryA]

I have found it unreliable in every version I can remember, back to 2000 and possibly 97.