loExcel.DisplayAlerts= .F.
>I want to do the following:
>
>1) Export a XLS file from a VFP database.
>2) Load the new XLS file into Excel using CREATEOBJECT("Excel.Application")
>3) Save the application so that it will convert from the older version of Excel (from the export) to a later version (Excel 97).
>
>However, I have to manually select "Yes" from the questions "Do you want to save the file?" and "Do you want to change the format?"
>
>It there a way to eliminate these warning questions and just autaomatically save the file using Office (Excel) Automation?
>
>Thanks,
>Robert
>
>PS: The reason I want to use the export feature of VFP is because it is so much faster than writting the records out one at a time.