Hints, tips and tricks for newbies
Moderators: Dorian (MJT support), JRL
-
Rick0825
- Junior Coder
- Posts: 28
- Joined: Sun Mar 05, 2023 5:30 pm
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
-
Grovkillen
- Automation Wizard
- Posts: 1062
- Joined: Fri Aug 10, 2012 2:38 pm
- Location: Bräcke, Sweden
-
Contact:
Post
by Grovkillen » Fri May 31, 2024 7:27 pm