Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- xl := ComObjActive("Excel.Application") ;Connects to the active Excel workbook
- row = 1
- #0::
- customerID := Floor(xl.Range("A" . row).value) ;set the clipboard to the value in cell A1
- Haystack := xl.Range("F" . row).value
- Needle = Apt
- StringGetPos, pos, Haystack, %Needle%
- if pos >= 0
- Line1 = % SubStr(Haystack, 1, pos)
- Line2 = % SubStr(Haystack, pos + 1)
- send %customerID% %Line1% %Line2%
- row ++
- return
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement