how to save dynamic data to a spreadsheet with only two columns

[Duran]

I was looking for similar information therefore the previous submissions were extremely useful. I am now trying to call a ready template of spreadsheet and trying to dump all the data  into 3 seperate columns the already programmed spreadsheet will automatically raphs and calculate some values and then I can rename and save it for archiving. Could you advice me how to call an already programmed spreadsheet then write/dump some readings.

Regards

Duran

[nimic]

Hello, Duran,
one way would be to delve deep into the dungeons of Dynamic Data Exchange aka DDE.
There you'd open a DDE-connection to Excel, request it to open the desired file and poke data into the now opened file at specified locations. After poking, close DDE-channel and continue in Excel as desired.
There is a small demo for MSAccess in the Example library that you could use as a starting point. If that proves to difficult, repost.

The dde functions are not in the regular function palette, but you can get them by selecting
/'your LV path'/vi.lib/platform/dde.llb

Good luck
Michael

[Duran]

Thanks Michael,

I think the way you are suggesting is a potential solution to my problem but I am quite new to Labview programming and not sure how to start. I have attached the VI I am working on could you help me to progress with this problem

Thanks again

Duran

[nimic]

Sorry - can you save it in a 8.0 vi? I have not updated yet... thnx

[Duran]

I hope this will be better.Thanks very much

[nimic]

Sorry - there was some loading error due to an ExpressVI not supported in 8.0. I'll look for an updated machine here and see what I can do...