Hi Glenn, try this:

Application.DisplayAlerts = False
Workbooks("YourWorkbook.xls").Close
Application.DisplayAlerts = True

If you want to immediately close right out of Excel then replace the second
line with Application.Quit.

"Glenn Rathke (Soft Design Consulting)" wrote:

I'm reading/writing Excel data to SQL Server thru VBA. As such I do not
want to be prompted to save the data when closing down Excel. How can I do
this?


--
Thanks
Glenn