Function or similar to execute commands Topic is solved

[DanielMendis]

Hi All

I am trying to define a function that incorporates some simple commands so that the cursor jumps to a certain cell in Excel. Here is my script:

Code: Select all

GoToCell(x){
WinActivate, Excel, 
Send, {CTRLDOWN}g{CTRLUP}
WinWait, Gehe zu, 
Send, x{ENTER}
Sleep, 500
}
Return 

#^8::
GoToCell (B3)
Return 

So as you can see I defined the function GoToCell and try to call it with the value B3 (which should replace the "x" in the function). I think this is probably not the right way to do it so any help would be very appreciated!
Thanks Daniel

[boiler]

You have two lines with syntax issues. This line would need % around the variable x:

Code: Select all

Send, x{ENTER}

And this line cannot have a space between the function name and parenthesis, and B3 would need to be in quotation marks:

Code: Select all

GoToCell (B3)

The first Return line does nothing where you have it and isn’t needed anywhere in this script.

To understand when and how to use expressions and legacy syntax, see the documentation on Expressions, Legacy Syntax, and Expressions vs Legacy Syntax.

[mikeyww]

Code: Select all

#IfWinExist ahk_exe EXCEL.exe
#^8::
WinActivate
excelGoToCell("B3")
Return
#IfWinExist

excelGoToCell(cell) {
 ComObjActive("Excel.Application").Range(cell).Select
}

[DanielMendis]

Code: Select all

excelGoToCell(cell) {
 ComObjActive("Excel.Application").Range(cell).Select
}

Thanks mikeyww, this looks interesting I have to examine this a little bit more to understand what you are doing but I am sure it is a good way.

[boiler]

It's a better way because it doesn't rely on the Excel window being active and keystrokes being sent/received, which is not 100% reliable.