Having an issue during my ForEachRow activity. I have successfully captured the text I want via GetText (I used a message box to confirm and each time it looped a new message box with the info popped up) and assigned it a variable. What I now want to do is input that data into the same row but in a different column.
So right now I have:
AttachToWindow (for the app I need to use)
TypeInto (where Im using row(0).ToString)
SendHotkey (to start query)
GetTexts (9 total)
And then I run into my issue of not having a way to export those variable from the the GetText back into the excel file.
I tried using WriteCell using “Sheets1” - row(2) and then the variable for the input. It kept throwing an error “Option Strict On disallows implicit conversions from ‘Object’ to ‘String’” so I tried row(2).ToString, still no effect.
Thanks in advance!