autohotkey

AHK : Parse data from excel (ignore empty rows and cells)

Buffer := clipboard
Loop, parse, Buffer,`n, `r
{
    if not A_LoopField
        continue
    Loop, parse, A_LoopField, `t
    {
        if not A_LoopField
            continue
        if (A_Index <> 1)
            Send {tab}
        Clipboard = %A_LoopField%
        Send ^v
    }
    Send `n
}
Clipboard := Buffer

excel autohotkey

Text only - Permalink - Snippet public post date 11/03/2015

AHK : Add program to startup

; Create shortcut (if it exists already, will be overwritten)
FileCreateShortcut, %A_WorkingDir%\vpn.exe, %A_Startup%\vpn.exe.lnk

autohotkey

Text only - Permalink - Snippet public post date 10/03/2015

AHK : Run Window Spy

#F2:: Run "C:\Program Files\AutoHotkey\AU3_Spy.exe" ; Sfl : Run Window Spy

autohotkey

Text only - Permalink - Snippet public post date 10/03/2015

AHK : WaitForImage

WaitForImage(ByRef pic, ByRef windowRef, ByRef timeout)
{
coordmode, pixel, screen
WinGetPos, winX, winY, winWidth, winHeight, %windowRef%
waitVal = 100
count = 0
maxIter := timeout / waitVal
while count < maxIter
{
    IfWinNotActive, %windowRef%
        WinActivate, %windowRef%
    ImageSearch, imageX, imageY, winX, winY, winX+winWidth, winY+winHeight, %pic%
    if not ErrorLevel   ; Found !
    {
        coordmode, pixel, Relative
        return true
    }
    Sleep waitVal
    count += 1
}
coordmode, pixel, Relative
return false
}

autohotkey

Text only - Permalink - Snippet public post date 09/03/2015

AHK : SelfReload

~^s:: ; Slf : Reload script on save
WinGetActiveTitle, Reload
    If InStr(Reload, "myscript.ahk")
        Reload
Return

autohotkey

Text only - Permalink - Snippet public post date 09/03/2015

AHK : FileRewrite

FileRewrite(ByRef FileName) ; Store clipoard content in file
{
Send ^c
ClipWait
FileDelete, %FileName%
FileAppend , %clipboard%, %FileName%
}

autohotkey

Text only - Permalink - Snippet public post date 09/03/2015