search words in a excel file

[alan4]

that the example i want to read...i think you will help me, i am using labview 2009

and i want to search for example: Dev5/ai3

thats all..

😞

[Aarthi_Arvindh]

May be this vi helps, search in text can be done by selecting the type as string.
Here is the attachment. Is this the one you want?

Also Gak, i am here to learn new things.I will not take it offensive and also

i have not worked with formulas in excel from labview. I will explore it. 

[alan4]

thanks aarthi!!!but i haven't got the NI_excel.lvclass....

so i can't work with this...

[Aarthi_Arvindh]

Ya you told in the last post, i forgot that.
As we discussed, try using ActiveX.
Can you post your vi? How you are retrieving from file?

[alan4]

can you tell me where in where module is the error that appears me??? that i don't have the lvib....

[Aarthi_Arvindh]

Do you have report generation toolkit?

[alan4]

no i don't

[Gak]

Hi Alan,

Please find attached code, to access excel using ActiveX. Open Trial1.vi. (for Example)

You can read data search string (As explained in one of the post, to use for loop n all). If you find then stop loop, else change sheet number and continue search.

[alan4]

so i cant pass the pages automaticly,

can be with a for?

[alan4]

in the vi you have send me, i don't know how to search something... where i insert the string i want to find??

if i change the range appears an error...