beatified
asked on
Set a variable to a sheet and cell in Excel AutoHotKey
I am trying to set a variable to the value of Cell F1 on sheet %DepNum% But not figuring it out as of yet.
Cell F1 is a countif in Excel to count the number of fields that aren't blank.
Cell F1 is a countif in Excel to count the number of fields that aren't blank.
SourceFile:="C:\Users\beatified\Desktop\AHK\Copy of Deposit Form.xlsx"
InputBox, DepNum, Deposit Number, Enter the Deposit Number you would like to process
NumberColumns:=9
Output:=""
ColumnLetters:=["A","B","C","D","E","F","G","H","I"]
oWorkbook:=ComObjGet(SourceFile)
oExcel.Sheets(DepNum).Select
ExcelCells:=Object()
NumberRows:=oWorkbook.Worksheets(DepNum).Range(F1).Value
Loop,%NumberRows%
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.