>I am writing an excel automation sample to export data to excel from a query. I would like to save a file, without the prompt.. i.e. force the save.
>
>I am creating the object from a template, the issue is when I do the save as, I get the following error about it being a different version of excel and some information would be lost. (Nothing will, there are no formulas...)
>
>How do I force a save, and ignore this error?

Set the XL Application object's DisplayAlerts to False.