I am looking for an automatic overwrite in ActiveX for MS Excel

[James Mc.]

I am trying to open a MS Excel spreadsheet add data and then save it. Currently I have to click a dialog box stating I want to overwrite the existing file. Is there a way to get around this or do it automatically.

[shawn]

There is a Knowledgebase that discusses this very issue, and an example for LabVIEW 6 of how to do it. You can go to www.ni.com and search for "+activex +excel +save" (without the quotes), or use the link below:
http://digital.ni.com/public.nsf/3efedde4322fef19862567740067f3cc/702b1bd0123a15128625695e00564983

[Gorka Larrea]

There's an activeX property node called Workbook>>Saved that should work wor that, but don't forget to really save the workbook before, this option only avoids excel to know there have been changes. Hope this helps.