Invalid Variant Operation error on XLGet

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
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
WindowAction>1,Sample - Excel
XLSelectRange>xlBook2,Sheet1,E11 <-- I get the error on this line

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

Re: Invalid Variant Operation error on XLGet

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


Running: 15.0.24
version history

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