Click to See Complete Forum and Search --> : excel and vba


comatosis
August 24th, 2001, 01:44 PM
Hey all, I'm pretty new at VBasic. I'm writing a program to read data from a NI-DAQ, put in on an updating graph, and put the values in a spreadsheet.

the format is up to 9 columns, the first one for the timestamp, and the value of each of the up to 8 channels in their respective columns. What I need to know is how to write a loop to put the values in the cells, then move down to the next row, put the timestamp in, and put the values in and so on...

The values are stored in CWAI.Channels, each channel in a variable called Chan.

It'll probably be something like

For Each Chan in CWAI.Channels...

Any help is greatly appreciated.

Thanks in advance,
Ricky