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.