Invalid Variant Operation error on XLGet

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
Rick0825
Junior Coder
Posts: 25
Joined: Sun Mar 05, 2023 5:30 pm

Invalid Variant Operation error on XLGet

Post by Rick0825 » Fri May 31, 2024 1:19 pm

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

User avatar
Grovkillen
Automation Wizard
Posts: 1048
Joined: Fri Aug 10, 2012 2:38 pm
Location: Bräcke, Sweden
Contact:

Re: Invalid Variant Operation error on XLGet

Post by Grovkillen » Fri May 31, 2024 7:27 pm

Let>ME=%Script%

Running: 15.0.24
version history

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts