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

Works like a charm!
Thanks again,
Mike