Code: Select all
SetFocus>Book1 - Excel
XLOpen>tmp0,1,xlBook
Wait>3.0
//Maximize Window
WindowAction>1,Book1 - Excel
Wait>1.0
XLSelectRange>Book1,Sheet1,B3:B16
Wait>1.0
Moderators: Dorian (MJT support), JRL
Code: Select all
SetFocus>Book1 - Excel
XLOpen>tmp0,1,xlBook
Wait>3.0
//Maximize Window
WindowAction>1,Book1 - Excel
Wait>1.0
XLSelectRange>Book1,Sheet1,B3:B16
Wait>1.0
Code: Select all
XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook
XLAddSheet>xlBook,Customers
XLSetCell>xlBook,Customers,1,1,CustID,xlRes
Code: Select all
XLOpen>c:\path\to\myfile.xlsx,1,xlBook
Wait>3.0
SetFocus>Book1 - Excel
//Maximize Window
WindowAction>1,Book1 - Excel
Wait>1.0
XLSelectRange>xlBook,Sheet1,B3:B16
Wait>1.0
Code: Select all
SetFocus>Book1 - Excel
//Maximize Window
WindowAction>1,Book1 - Excel
Wait>1.0
XLSelectRange>xlBook,Sheet1,B3:B16
Wait>1.0
Code: Select all
XLGet>%USERDOCUMENTS_DIR%\mybook.xls,xlBook
XLAddSheet>xlBook,Customers
XLSetCell>xlBook,Customers,1,1,CustID,xlRes
Code: Select all
XLGet>Book1,xlBook
Wait>1.0
XLSelectRange>xlBook,Sheet1,B3:B16