how can i pull out data from a spreadsheet only from the current month?

[Ross h]

Data is constantly being fed into a spreadsheet using a VI, this data comprises of such things as month, year, weights, std dev, etc.  I want to do some data manipulation on the current months data while the VI is running, how can I pull out only the data relating to the current month?  Each input into the spreadsheet stores the values for that run on one row, and there are perhaps 150 runs each month

Any thoughts are greatefully received

Thanks

Ross

[AdamB]

Morning Ross h,

Do you actually write the data to a .xls file or a .txt file?  It would be a lot easier and less processor hungry to use .txt files, as with .xls files you would need to use ActiveX functions.

AdamB

National Instruments

[AdamB]

Hi Ross,

I thought I would go away and make you an example VI for the results xls that you have sent me.

Here it is:  I have added a few comments here and there but if you need more info please don't hessitate to post back on the forum

Hope if helps

AdamB

National Instruments

[Ross h]

Thanks, I am afraid I only have version 7.0, and so the VI will not open.

Thanks

Ross

[AdamB]

Hi Ros,

I've saved you a version of the code that will run for 7.0

Try this

AdamB

[Ross h]

It works!!

Thank you very much

Ross