Hi,

I opened a new session of excel and kept the personal macro file unhidden.
Then I opened a new worksheet book1.

In VB I inserted a module in Book 1.

Then I wrote this code.

Surprsingly, excel saved book 1 in my Xlstart folder along with the personal
macro workbook. ( I had not saved Book 1)

Sub closingexcel()
Application.DisplayAlerts = False
Application.Quit
Workbooks("book1").Save
Workbooks("personal").Save
End Sub

Regards,
Hari
India