Forum Discussion

kandy1984's avatar
kandy1984
Contributor
6 years ago

Using data from excel sheet for FindChild and passing as regex

Hi Everyone,   Thanks for helping. I am using a findChild method and passing in the properties from excelsheet.   Set Loading= Aliases.DataAcquisition........            PropArray = Array("...
  • tristaanogre's avatar
    tristaanogre
    6 years ago

    Simply concatentate the string...

     

     

    ValuesArray = Array("*" & Driver.Value(1) & "*")

     

    This will put the value from that column in the array appropriately.

     

tristaanogre's avatar
tristaanogre
Esteemed Contributor

Simply concatentate the string...

 

 

ValuesArray = Array("*" & Driver.Value(1) & "*")

 

This will put the value from that column in the array appropriately.

 

kandy1984's avatar
kandy1984
Contributor
6 years ago

Thank you