Hi Cetin,

The dialog box did not pop up now when I add oExcel.DisplayAlerts = .f.
But all the changes on the format did on the excel file was lost.

Before I add oExcel.DisplayAlerts = .f. in my code, I noticed that when the dialog box was popped up, the 'no' button got the focus. When 'No' is clicked, all the changes will be lost.

I need to click on the 'yes' button in order to update the file to the new format.

How can I solve this.