Import Cell Range in Excel ActiveX

[mclaugb]

I cannot seem to get ActiveX to grab the last line of an excel file.  I have attached the activex vi and the data i am trying to import.
I didnt write the activex VI so i am not sure how to edit it. 
Note, I really only want to get one cell (B:803) out of this file so i find it a bit of a waste to use the read spreadsheet file VI and then just truncate off what i do not need.  Perhaps that is still faster than this activex approach.

Kind Regards,
Bryan

[DavidJCrawford]

Brian

You don't need to use ActiveX with that text file. There is a little bit of manipulation but the result is what you require.

Hope this helps

David

Message Edited by David Crawford on 10-05-2006 11:42 AM

[K C]

Hi Brian,

I agree with David. This is a better way to read the text file.

I you still want to get your VI working rename your .txt file to a .csv and you read a smaller range.

[mclaugb]

thanks alot for that.  This is a much better solution!
Bryan

[mclaugb]

I also found it works without the search and replace.  The file i sent was actually a .csv that the forum server wouldnt let me upload so i changed the extension to .txt
why did you use the search and replace with an empty replace value?
Bryan

[DavidJCrawford]

It was to remove the <tab> characters leaving only the commas. It tidies up the data structure. In hindsight it probably was not needed but I only like to work with one delimiter. Force of habit I suppose.

David