Invalid Variant Operation error on XLGet

[Rick0825]

I read some old posts about getting errors with XLGet function and was hoping new information was found about it. My spreadsheet was working fine and then without warning I get an error. I also tried adding the full path to the excel file XLGet>C: fullpath/Sample.xlsx,xlBook2 and that did not work either. The only fix is closing it and re opening between scripts.

Code: Select all

SetFocus>Sample - Excel
Wait>1.0
XLGet>,xlBook2
WindowAction>1,Sample - Excel
Wait>1.0
XLSelectRange>xlBook2,Sheet1,E11 <-- I get the error on this line
Wait>2.0

[Grovkillen]

You're not giving the command a range. https://www.mjtnet.com/manuals/b/v15/to ... trange.htm

Use the XlGetCell instead: https://www.mjtnet.com/manuals/b/v15/to ... etcell.htm