SaveAs Excel sheet without prompt

[New_Coder]

Using VB code I am looking for a way to save an Excel sheet without getting a prompt (in Excel asking if I want to overwrite the file) and close the Excel without user intervention. I have created an Excel.application object (MyExcel), a book object (MyBook) and a sheet object (MySheet) Through code I dump my datagrid data to the Excel Sheet, and save the file to disk using MyBook.SaveAs (save_Path & Save_Name) MyExcel.activeworkbook.close true This works great if the file does not exist, but prompts me to overwrite the file if it does. Any Suggestions would be helpful :doh:

[ChandraRam]

Two things you can do... - delete file first, if it already exists - set DisplayAlerts to False in MyExcel object HTH

[New_Coder]

Thanks for the advice "MyCxcel.DisplayAlerts = False" did the trick :-D

[ChandraRam]

New_Coder wrote:

Thanks for the advice "MyCxcel.DisplayAlerts = False" did the trick

Glad it worked out for you... you are welcome. :)