online data entry copy paste

Get help with using AutoHotkey and its commands and hotkeys
dso gandhinagar

online data entry copy paste

14 Jun 2018, 07:18

hellow sirs, i am very new to this programming and all.
i am reading tutorial but cant get it. plz 1st let me know that what i am going to do is possible with Hotkey or not?

All i want to do is to open two windows. 1. chrome web page: from where i want to paste data 2. excel : from where i want to copy a cell ( then below cell after 1st cycle completed)
after opening these two windows i want to do this which can automate a set of keyboard press in repetitive manner for me.. that is, (ctrl+C alt+tab ctrl+A ctrl+v Enter alt+tab Downkey) again (ctrl+C alt+tab ctrl+A ctrl+v Enter alt+tab Downkey) and so on..

so, that i can enter a data from an excel column to governmental web portal.

please help, if i ll be helped i will help those who need this, this can save man hours of lot of employees.
GeekDude
Posts: 852
Joined: 02 Oct 2013, 22:13

Re: online data entry copy paste

14 Jun 2018, 10:15

It's hard to be completely certain without being more familiar with your work flow, but I think yes.

For example, this code would perform that action whenever you press the x key.

Code: Select all

x::Send, ^c{AltTab}^a^v{Enter}{AltTab}{Down}
mshafer1
Posts: 28
Joined: 16 Jul 2017, 14:49
GitHub: mshafer1
Contact:

Re: online data entry copy paste

14 Jun 2018, 11:12

Personally, I like to use a modified CTRL + C to keep inline with the idea of copying

Code: Select all

]
; trigger on CTRL + SHIFT + c - use $ to prevent recursion (that is the script uses ^c, so prevent this from calling itself)
$^+c::
    Loop, 1 ; increase this to repeat multiple times
    {
      Send, ^c
      Sleep, 300 ; let Windows do its thing
      ; Because Excel copies cells with an endline, trim the clipboard
      clipboard := Trim(clipboard, OmitChars := " `n`r`t")
      Send, !{Tab}
      Sleep, 300 ; let Windows catch up
      Send, ^a
      Send, ^v
      Sleep, 300 ; let Windows do its thing
      Send, {Return}
      Send, !{Tab}
      Sleep, 30 ; let Windows do its thing
      Send, {Return} ; Excel wants to have it clearly indicated that the copy command is finished
      Send, {Down}
    }
    return
ahkgen url: https://www.ahkgen.com/?length=1&commen ... on0=Custom

Return to “Ask For Help”

Who is online

Users browsing this forum: Ahk_fan, Bing [Bot], mast4rwang, Portwolf, SOTE and 56 guests