Search found 23 matches
- 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...
- 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...
- 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...
- 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
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
- 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...
- 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...
- 23 Jun 2021, 22:06
- 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
version 1.0.48.05
- 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...
- 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
- 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...
- 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...
- 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. ...
- 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...
- 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...
- 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
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
- 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 ...
- 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
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
- 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...
- 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!
- 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...