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?


TIA,
Mike