Search found 23 matches

by rolo6464
24 Jun 2021, 22:01
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

It's just a demo. You just change the stuff inside the braces to your own routine for each iteration. Perhaps the following: coord := [[237, 684], [408, 684]] If !WinExist("ahk_exe chrome.exe") { MsgBox, 48, Chrome, The Chrome window was not found. Return } Else WinActivate Loop, Read, C:\1.Busines...
by rolo6464
24 Jun 2021, 21:37
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

So I was able to remove the msg boxes and tested it thoroughly and its still doing the same as before. It exeucting the series of steps in between the 2 coordinate steps no after. to illustrate what its doing: 1. Click on coordinates 1 and paste text 2. series of steps i mentioned 3. click on coordi...
by rolo6464
24 Jun 2021, 21:22
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

I tried the above code but same issue, also don't get why there are message boxes now. i can't remove them because I have no idea what's needed and what is only for the msg box. The coordinates mouse clicks are executing in the right spots, but what isn't working is that its not in the right sequenc...
by rolo6464
24 Jun 2021, 14:14
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

Not sure if I did?

I can't get the code to do this part:

1. Click on coordinate 1
2. click on coordinate 2
3. run the series of steps I listed above
4. repeat loop
by rolo6464
24 Jun 2021, 10:05
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

My apologies! it turns out it was my version that caused all the issues. Sorry for wasting everyones time going aback and forth, i feel embarrassed. Anyway so I updated it and it runs however I do need a slight tweak as my set of procedures has to run after the 2 coordinate mousclicks. In other word...
by rolo6464
23 Jun 2021, 22:07
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

I pasted that exactly and I got " the following variable name contains an illegal character: "coord[A-Index].1" Your reported (and similar) error above shows a hyphen as part of a variable name coord[A - Index].1 which I can't see anywhere in mikeyww's code. - versus _ But I don't see why you would...
by rolo6464
23 Jun 2021, 21:42
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

So i took your first script and created the below but now its saying illegal character in the coord[A_Index].1 line. not sure why as It's exactly what you posted earlier. coord := [[237, 684], [408, 684]] Loop, Read, C:\1.HardDrive\test.csv Loop, Parse, A_LoopReadLine, CSV { MouseClick,, coord[A_Ind...
by rolo6464
23 Jun 2021, 21:37
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

Yes that's correct, I already have chrome open and ready to play the script
by rolo6464
23 Jun 2021, 20:16
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

Sure. When you test the first script that I posted, is it doing something different? With a small change to display activity a bit: coord := [[384, 254], [145, 254]] Loop, Read, %A_ScriptDir%\test.csv Loop, Parse, A_LoopReadLine, CSV { Send % coord[A_Index].1 " " coord[A_Index].2 "`n" Send %A_LoopF...
by rolo6464
23 Jun 2021, 20:11
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

Sure. When you test the first script that I posted, is it doing something different? With a small change to display activity a bit: coord := [[384, 254], [145, 254]] Loop, Read, %A_ScriptDir%\test.csv Loop, Parse, A_LoopReadLine, CSV { Send % coord[A_Index].1 " " coord[A_Index].2 "`n" Send %A_LoopF...
by rolo6464
23 Jun 2021, 19:41
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

You haven't provided a clear description of exactly what should happen. I think that the scripts have met what you did describe. Instead of debugging and going through them line by line, you seem to want to just put them aside and try the next thing-- but I also do not know what the next thing is. ...
by rolo6464
23 Jun 2021, 19:09
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

I'm not sure if this helps, but this seems to accomplish your goal. coord := [[384, 254], [145, 254]] Loop, Read, %A_ScriptDir%\test.csv ; Read each line of the CSV file Loop, Parse, A_LoopReadLine, CSV ; Parse one CSV line { MouseClick,, coord.1.1, coord.1.2 ; Click on first set of coordinates Sen...
by rolo6464
23 Jun 2021, 14:58
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

You have two different sets of coordinates. Should the script be alternating between them? yeah exactly Column A is coordinate 1 and Column B is coordinate 2. Alternatively I could shove all the dates into 1 column (column A) but it would still have to alternate coordinates, So A1 is coordinate 1 a...
by rolo6464
23 Jun 2021, 11:23
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

mikeyww wrote:
23 Jun 2021, 09:17
I think it will help if you can provide a sample CSV file, and then provide an example of exactly what the script should do, step by step.
attached is an example, just a basic 2 column file with dates, the example only has 4 rows but real one will be a lot longer, but exact same thing
by rolo6464
22 Jun 2021, 22:10
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

There may be more reliable ways with JavaScript or Chrome.ahk, but here is a basic kind of demo with the coordinates that you provided. I imagine that it would need adjustment. I really appreciate your reply. Unfortunately I wasn't able to make that work, my skills levels in programming just isn't ...
by rolo6464
22 Jun 2021, 18:56
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Re: Copy cells from CSV and Pasting into chrome

@mikeyww

Do you know the solution to this, as you solved a similar problem of mine last time, i'd be happy to pay you via paypal for this. Thanks
by rolo6464
20 Jun 2021, 18:08
Forum: Ask for Help (v1)
Topic: Copy cells from CSV and Pasting into chrome
Replies: 30
Views: 1615

Copy cells from CSV and Pasting into chrome

Hi guys, I'm stuck on this problem, would appreciate any help. I have a CSV that has 2 columns, A and B. And many rows in each column. They are simply dates I am trying to write a program that copies from column A1 and pastes it into a form in chrome. Then copies Column B1 and pastes it into another...
by rolo6464
15 Apr 2021, 00:25
Forum: Ask for Help (v1)
Topic: reading CSV cells and pasting it into chrome browser
Replies: 7
Views: 407

Re: reading CSV cells and pasting it into chrome browser

wow that worked, took a while to integrate it into my script but also suprised there was no "0" anywhere in the script yet it knew the interpret only that number. well shows how much i know, thanks a lot for your help with this!
by rolo6464
14 Apr 2021, 18:44
Forum: Ask for Help (v1)
Topic: reading CSV cells and pasting it into chrome browser
Replies: 7
Views: 407

Re: reading CSV cells and pasting it into chrome browser

Hey, thanks for your reply. I don't understand where it reads the part about it being a "0" and skipping to the next line: This is the code I have: file = C:\test.csv If !FileExist(file) { MsgBox, 48, Error, File not found. Aborting.`n`n%file% Return } Else FileRead, ttext, %file% If !WinExist(wTitl...

Go to advanced search