>>Hi all,
>>
>>In my program, I formatted the excel file created. When the excel file is formatted, a dialog box was popped up to ask me whether I want to update the excel file to the new format as the excel file created was in a previous version of microsoft excel.
>>
>>In my program, I formatted many excel files and I don't want to click 'yes' every time when this dialog box was popped up every time.
>>
>>Is there any way to use code to do it?
>>Thanks in advance.
>>
>>
>>
>>Mun
>
>oExcel.DisplayAlerts = .f.
>
>Cetin
Thanks <g>
If it's not broken, fix it until it is.
My Blog