>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.

oWorkbook.SaveAs(lcName,xlNormal).
Cetin