I would like to convert the ASCII data received through an RS 232 port from my flow meter to Excel data and save it to my PC continuosly.

[indiaan]

I would like to convert the ASCII data received through an RS 232 port from my flow meter to Excel data and save it to my PC continuosly. I would also like to create an template in Excel format with the required fields so as to save data on the Excel template every time i choose to run my flowmeter. I'm using Labview7 basic package. Pls. provide me with the required BLOCK DIAGRAM with complete connections.

[Dennis_Knutson]

I think that the simplest way to do is to write both header and data as a text file - either comma or tab separated. I prefer to use comma separated and if you use a .csv extension, Excel will automatically open it. This way you don't have to have Excel on every pc nor worry about the ActiveX methods and properites changing for different versions of Excel. The header can be created using Write Characters to File and the data can be written using Write to Spreadsheet File.