hear my tale of woe. I love AHK, but am having a wee spot of trouble getting it to trigger when I type a hotstring in the search box within Excel 2010.
My code is included below; basically, I want to manually open the search box in Excel, enter a search term while in "basic search mode", and finish off by typing my hotstring (++a in this case).
It should then remove the hotstring, and perform a few keyboard maneuvers that switches mode to "advanced search", toggles the search scope to include the entire workbook, and execute a "Find all".
Please note that the actual keystrokes sent are specific to the Danish localized version of Excel, so in case you try it for yourself as-is, it's likely to not yield the desired result.
Right now, it mostly yields no result at all, as AHK ignores the hotstring, unless it is the very first thing (leftmost) in the search box!
But I want to enter it as the last thing (naturally).
Code: Select all
:*:++a::
SendInput {Alt Down}l{Alt Up}{Alt Down}d{Alt Up}p{Enter}{Alt Down}n{Alt Up}
return
I'm using the latest regular version of AHK, downloaded today. Running Windows 10 Pro x64.