online data entry copy paste Topic is solved

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

online data entry copy paste  Topic is solved

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: 843
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: Bing [Bot], Google [Bot], masok, Portwolf, Rohwedder, tonkomnom, Xtra and 27 guests