Hi Laxmi,
In your script, you assign the objDriverSheet.Range("B1:B10") object to the eleventh element of the arrayA array, while its first element remains uninitialized.
You can obtain the range cell's values in the following way:
...
Dim c
For Each c in objDriverSheet.Range("B1:B10")
Log.Message c.Value
Next
...
You can find additional information in Excel's built-in VBA reference.
>
So i am trying to find out if it is possible to attach an already opened excel to this code and try to read\write data from that excel using the code.
<
You can use the OleObject property to do this (see the "OleObject Property" help topic).