active x to search cells

[Joe_H]

If you are just reading in everythinf cell by cell then what is the point of doing a search. If you are going to do it this way then why not just read everything into LV and perform the searches, it is a lot easier to do.

What is your end goal?

[chirs73]

In my spreadsheet, Column A has Serial Numbers for the PCB's I am testing. What I need to accomplish is have my search take the number out of column A and place it on a display on the front panel. THen on the next iteration of the test pull the next serial number in the sequence.

[Joe_H]

So again, what is the need for using the search. It would work better for you if you would read in the entire file and use straight LV functions to accomplish this. trying this in Excel using active X is doable but you would have better luck using straight LV

[chirs73]

So that the testers won't accidentally screw up and double assign 1 serial number. I need the search to pull up the next available s/n to assign to the BUT.

[smercurio_fc]

Now that you've given more information I also don't see why you need to use Excel to do this. This seems like a straightforward text file read with an indexing for the serial number.

[chirs73]

I am trying this but can't seem to figure out how to tell the text file where to read.

[Joe_H]

So let me get this straight:

1. You have a file that in one column has a set of predetermined serial numbers.
2. You want to search this file for a serial # and make sure that it has not been assigned to a unit.

Are these assumptions correct. If they are correct or close then you would definetely benefit from just using straight LV. What I would do is at the start of my program i would read in the entire file (Excel or text file) then I would key off an event to to search for the serial # in the file, ie the user enters in the serial number. then I would somehow indicate to the user that serial # has been used previously. if this is close then you could do something like the attached VI.

[Joe_H]

Why don't you post what you already have and let us have a look and see if we can give a more in depth answer as to what you are doing wrong.

[chirs73]

You are close to having it straight. Yes I do have a file that in one column has a set of predetermined s/n. What I am trying to do is at the start of my test have labview go into the file and extract the next s/n in line to be used and display it on the front panel so the tester does not have to worry about assigning. The file itself will assign the serial number when the test button is pressed.

[chirs73]

I haven't written any code that i could post. Originally my first revision of my test was expecting the user to enter a s/n. I got a lot of flack for that b/c the people I work with are lazy and want everything done for them. So my next step in revising the test was to have the test search the spreadsheet to see if the s/n had already been tested. I have shifted slightly and am trying to see if there is a way to code this so the program will extract the next consecutive s/n and that way the people testing will be happy (for now).