table into excel file

[rizwan bajwa]

i have made this programme to get my measured data in excel file(voltage at ch1,ch2 ratio ch2/ch1)only prolem left is this that i have to make different number of run for measurments but it open each time a new excel file but i want to get all run results in same one excel file without opening new one how i can do this????

best regards

rizwan bajwa

[GerdW]

Hi tizwan,

as long as all those subVIs from ole-excel.llb are missing we can't tell much...

General suggestion:

Open the original excel file, search for the last row of results, append new results in the next row!

[smercurio_fc]

The subVIs were not included, but based on the names, it appears you are using some library that uses an OLE connection to Excel. Is there a reason for using this method as opposed to ActiveX?

Code comments:

• Why a for-loop. You have a Stop button, which seems to imply you're intending a while loop there.
• Do not initialize and close the serial port with each iteration. Open once. Close once.
• Why the 3 loops at the bottom? They seem to make no sense for being there.