Hi
you should try to first save the files and the quit the application.
Also Excel saves the file in the current directory. So you may change
the directory first in your macro
--
Regards
Frank Kabel
Frankfurt, Germany


Hari wrote:
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