help to copy data from excel cells to web browser fields

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
guiduz
Posts: 4
Joined: 18 Apr 2016, 05:45

help to copy data from excel cells to web browser fields

18 Apr 2016, 05:56

Hello to all.
I'm new with Autokey.
I need help to copy data from excel cells to web browser fields.
To better explain:
I have spreadsheets with data, I need to copy all of this data on consecutive fields in the web browser (I use chrome). I can select them all together, because they are on the same column.
My idea is to use a hotkey to copy the column, then I move on chrome and i can use another hotkey to paste on different and consecutive fields.
Please Help
guiduz
Special-K
Posts: 2
Joined: 17 Dec 2015, 12:05

Re: help to copy data from excel cells to web browser fields

18 Apr 2016, 06:29

All depends on
1) What youre spreadsheet looks like
2) What the website looks like
guiduz
Posts: 4
Joined: 18 Apr 2016, 05:45

Re: help to copy data from excel cells to web browser fields

18 Apr 2016, 08:53

I need only to know how to paste some data (that i have copied from excel), to the fields of the web page.
I would copy the (for example) 10 cells in excel, and then, i would paste on the web page fields, as if i pres tab between every data.
I hope i explained.
Thanks
User avatar
Blackholyman
Posts: 1293
Joined: 29 Sep 2013, 22:57
Location: Denmark
Contact:

Re: help to copy data from excel cells to web browser fields

18 Apr 2016, 09:23

Code: Select all

send ^c ; copy
Winactivate, browserWinTitle
Send ^v ; paste
Sleep 200
Send {tab}
WinActivate, excelWinTitle
If you need more help you need to tell us more
Also check out:
Courses on AutoHotkey

My Autohotkey Blog
:dance:
guiduz
Posts: 4
Joined: 18 Apr 2016, 05:45

Re: help to copy data from excel cells to web browser fields

18 Apr 2016, 09:40

First of all thanks for the help!

I try to explain.
I would manually select and copy the cells in excel, using ctrl + c.
Now I have in the clipboard the list of data that I need to paste in different fields on the browser, one by one.

At this point I need a macro that, after placing the cursor on the first field, by pressing a button, it will paste the data that I have in memory, one by one, in the browser fields, consecutively one by one (the first in the first field, the second in the second field...and so on) (As if I did ctrl + v to paste the first data, and then I press the tab key to move to the next field, then press ctrl + v, for the second data, etc.)
Thanks a lot
guiduz
User avatar
Blackholyman
Posts: 1293
Joined: 29 Sep 2013, 22:57
Location: Denmark
Contact:

Re: help to copy data from excel cells to web browser fields

18 Apr 2016, 09:53

Code: Select all

clipsave := clipboard
Loop, parse, clipsave, `n, `r
{
    Clipboard := a_loopfield
    Send ^v
    Sleep 200
    Send {tab}
}
Also check out:
Courses on AutoHotkey

My Autohotkey Blog
:dance:
guiduz
Posts: 4
Joined: 18 Apr 2016, 05:45

Re: help to copy data from excel cells to web browser fields

18 Apr 2016, 11:25

And how can i use the code?
sorry, i'm really new
VBAuser

Re: help to copy data from excel cells to web browser fields

20 Apr 2017, 09:44

This code copies an entire row of Excel data into one single field.
How to make jump by cells, not entire rows?
soulshak

Re: help to copy data from excel cells to web browser fields

25 Sep 2017, 02:46

Blackholyman wrote:

Code: Select all

clipsave := clipboard
Loop, parse, clipsave, `n, `r
{
    Clipboard := a_loopfield
    Send ^v
    Sleep 200
    Send {tab}
}
Hello

Can someone give a help, this script works so great that make me a lot of time save but i need some improve.

I can copy one column from exel to copy into www field (some kind of data base in my company) but when i copy 2 column or more i want to script take that 2 column as 1 long one and when one end it should take data from next one. Now script copy row with data from column 1 and 2 and second row with column 1 and 2 etc...

So i need to copy few column in exel and copy into www field same way as script do but one by one and when first column end it should start copy data from next and then from 3 and so.

Thanks if someone give me a some help

Return to “Ask for Help (v1)”

Who is online

Users browsing this forum: No registered users and 121 guests