Excel should prompt to save. To test that I ran this script (copy and save
as a VBS file):

Dim XL
Set XL = CreateObject("Excel.Application")
XL.Workbooks.Add
XL.Activesheet.Range("A1").Value = "x"
XL.Visible = True

Quiting Excel without doing a thing I got a save prompt.

--
Jim
"Simon Woods" wrote in message
...
| Hi
|
| I'm automating Excel from VB, populating a sheet and then showing the
user.
| The user may or may not make chnages to this sheet. When the user closes
| Excel, the user is not prompted to save changes, but rather Excel closes
| down without asking. Is there a flag or something I can set to force Excel
| to prompt for save changes if any changes have occurred to this sheet.
|
| Thanks
|
| Simon
|
|