Write Table to XL sample

[toh]

Greetings to all NI application engineers and programming experts.

I have downloaded a write table to XL spreadsheet from the labview example. This sample added a new sheet to the existing file whenever a new table of data is transferred. If I want to save the new data again and again on the same worksheet, how could I do it? Sincerely hope that anyone could help me modify this sample to cater to the above needs as I do not have knowledge with ActiveX property and methods control. Thanks a lot.  

[Kenny_K]

Are you looking to append data to the same sheet, or to rewrite data on teh same sheet each time you save??  Also, are you looking to ahve excel open and stay open, or to have to save to excel "behind the scenes"?

[toh]

I am looking to rewrite or replace the existing data everytime I save. I would like to have the excel stay open when opened. Thanks a lot for responding to my enquiry.

[Kenny_K]

Try this vi and see if it works for you

Kenny

[toh]

Thanks but can you save it in version 7.1. I cannot open this VI.

[Kenny_K]

Here you go

[rogue]

can sombody save it in version 7.0??

[Kenny_K]

here is version 7.0

[toh]

It does works for me. Thank you.

[vaib]

Hello Everybody I have an opposite problem I donnot want my data to be erased when loops reinitialize/go around for second time. Please let me know of some appropriate modifications for my vi.