ActiveX is not the speediest method to use. A faster way would be use
Write to Spreadsheet File which creates a text file as either tab or
comma separated data. Excel is capable of reading either. The fastest
method is save the data as a binary file and export it later into
Excel. Look at the examples called High Speed Data Logger and High
Speed Data Reader for how to work with binary files. If you absolutely
must write to an Excel file real-time, make sure you're not opening
and closing Excel each time. Have Excel open before you start your
acquisition, keep appending data to the same file or a different
worksheet in the same file and close Excel at the end of the
acquisition.

Reply via email to