How do you suppress the overwrite file prompt when using Write to Spreadsheet VI?

[Ken54]

Can the overwrite file prompt be suppressed when using the Write to Spreadsheet VI?  If so, please tell me how to suppress it.  If not, is the best work around to eliminate the prompt to delete the existing file before using the Write to Spreadsheet VI?

[johnsold]

I don't think you can do it directly from the write to spreadsheet VI. However if you save copy with a different name and to a location outside vi.lib, then you can modify it. The Open/Create/Replace File.vi has an input for advisory dialogs. Connecting a False to that should do it. Be sure to save a copy as I mentioned. Otherwise other programs trying to use the standard write to spreadsheet VI will not work as expected and the next upgrade of LV may undo all your work.

Lynn

[jbrohan]

Hello
Delete the file before you write it! look at http://forums.ni.com/ni/board/message?board.id=170&message.id=147845 for a simple version of this.
John