From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
05-07-2015 09:40 AM
Hello,
I have develloped a VI which finds a value in an excel workbook, and I need a way to collect the row of the cell containing this value.
Thank you for your help
Solved! Go to Solution.
05-07-2015 10:09 AM
@Hind wrote:
Hello,
I have develloped a VI which finds a value in an excel workbook, and I need a way to collect the row of the cell containing this value.
Thank you for your help
That might depend on how your code is written (ActiveX? RGT?), you should attach your vi.
Ben64
05-07-2015 10:10 AM
How do you find the value?
05-07-2015 10:41 AM
05-07-2015 10:52 AM
@Hind wrote:
I use the activeX find
Then use the Row property on the range object returned by theFind method.
Ben64
05-07-2015 11:38 AM
I have already tried it and it always returns row = 1. I have attached the VI and thank you for your response.
05-07-2015 11:45 AM
My mistake I was using the range object returned by the replace method!
Thank you once again !