How to store a value from InnerText property to an Array ?

[basanth27]

What is the necessity of a array to find out existence of a particular substring in a string ?

this should do,

Code:

str = "Sunday Monday Tuesday"
strtoverify = "Monday"

If Instr(str, strtoverify) <> 0 Then
   msgbox "found"
Else
  msgbox "not found"
End If

I fail to understand what you would want to write to the Datatable ? Is it the Innertext ? I presume so, if thats the case then you can simply write it as,

Code:

Datatable.Value("Innertext",dtglobalsheet)=str

See if this helps !!!