AutoHotkey Community

Let's help each other out
https://www.autohotkey.com/boards/

Detect Chrome page loaded

https://www.autohotkey.com/boards/viewtopic.php?f=76&t=91012

Page 1 of 1

Detect Chrome page loaded

Posted: 27 May 2021, 13:02
by NewYears1978
I've got a script I use to automate some clicking for pulling reports on my website, after each run it takes 10-30 seconds for the report to run and I want to wait until the loading is done in Chrome before moving on to the next loop. I tried the below but the cursor doesn't always show a "wait" cursor so it won't work. There's always a spinning loading icon in the Title bar next to the name (in the tab) but otherwise there's nothing indicating loading. The page doesn't change so the page itself is not loading it's simply sending SQL queries to our database.

Aside from just putting a 45 sec delay is there any way to detect that loading icon in the tab bar?

Code: Select all

!1::
Macro1:
Loop
{
    Sleep, 333
    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

while (A_Cursor = "AppStarting" or A_Cursor = "Wait") ; Wait for browser
  continue
Sleep, 100
}
Return

Re: Detect Chrome page loaded

Posted: 27 May 2021, 13:34
by boiler
You can use ImageSearch to keep checking until the refresh icon that appears in its place appears.

Re: Detect Chrome page loaded

Posted: 27 May 2021, 13:56
by boiler
Looking at it again, it looks like in the latest versions of Chrome the refresh icon doesn't appear in place of the "busy" circle any more, rather it is in place of the "X" for stopping the page load. So that's where you would search for the refresh icon to appear again.

Re: Detect Chrome page loaded

Posted: 27 May 2021, 14:15
by NewYears1978
I think an easier way I have disconvered is to use FileExist, because each little run of the script creates a file and they are inclemently named

Filename
Filename(1)
Filename(2)

Etc.

I tried this but it doesn't seem to continue once the file is created. Did I do it wrong?

Code: Select all

!1::
Macro1:

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While ! FileExist("C:\Users\jpyle\Downloads\CustomerAssignments.csv")
   Sleep 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

Re: Detect Chrome page loaded

Posted: 27 May 2021, 14:49
by boiler
That should work. After the file is there, see what this one-line script shows just to make sure there's nothing wrong with the path:

Code: Select all

MsgBox, % FileExist("C:\Users\jpyle\Downloads\CustomerAssignments.csv")

Re: Detect Chrome page loaded

Posted: 27 May 2021, 14:55
by NewYears1978
boiler wrote: ↑
27 May 2021, 14:49
 That should work. After the file is there, see what this one-line script shows just to make sure there's nothing wrong with the path:

Code: Select all

MsgBox, % FileExist("C:\Users\jpyle\Downloads\CustomerAssignments.csv")

Wow I am dumb, forgot a folder. Lol. I swear I looked at it 100 times but missed it because the filename and folder name is the same so it ran together.

Thanks! Trying again.

Re: Detect Chrome page loaded

Posted: 27 May 2021, 15:00
by NewYears1978
boiler wrote: ↑
27 May 2021, 14:49
 That should work. After the file is there, see what this one-line script shows just to make sure there's nothing wrong with the path:

Code: Select all

MsgBox, % FileExist("C:\Users\jpyle\Downloads\CustomerAssignments.csv")
I think I may have triple posted due to the mod regulartions right now, I apologize.

So I DID have the path wrong, I missed the folder..lol. But I added it and it still does not work. The MsgBox shows "A" when I run it.

Maybe my full script is wrong, and I know this is super sloppy and there's probably some way to loop this..but I don't know AHK enough (in VBA I would use an i loop or something instead of repasting the code 35 times).

Code: Select all

Escape::
ExitApp
Return


!2::
Macro2:
MsgBox, % FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments.csv")
Return

!1::
Macro1:

    Click, 225, 265 Left, Down
    Sleep, 10

    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist(" C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments.csv ")
Sleep, 250


MsgBox, File is Available

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(1).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(2).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(3).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(4).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(5).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(6).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(7).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(8).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(9).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(10).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(11).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(12).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(13).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(14).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(15).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(16).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(17).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(18).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(19).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(20).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(21).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(22).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(23).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(24).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(25).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(26).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(27).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(28).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(29).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(30).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(31).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(32).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(33).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(34).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments(35).csv")
  Sleep, 250

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

    Return

Re: Detect Chrome page loaded

Posted: 27 May 2021, 15:18
by NewYears1978
I finally got it, this is what worked - I just need to change it to activate the window now because if I move the mouse to another screen then it messes it up.

Code: Select all

Escape::
ExitApp
Return



!2::
Macro2:
MsgBox, % FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments.csv")
Return

!1::
Macro1:

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments.csv")
{
  Sleep, 250
}

    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (1).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (2).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (3).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (4).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (5).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (6).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (7).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (8).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (9).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (10).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (11).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (12).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (13).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (14).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (15).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (16).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (17).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (18).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (19).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (20).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (21).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (22).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (23).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (24).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (25).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (26).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (27).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (28).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (29).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (30).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (31).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (32).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (33).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (34).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments (35).csv")
  {
  Sleep, 250
}


    Click, 225, 265 Left, Down
    Sleep, 10
    Click, 225, 265 Left, Up
    Sleep, 10
    Send, {Down Down}{Down Up}{Enter Down}{Enter Up}
    Click, 730, 291 Left, Down
    Sleep, 10
    Click, 731, 291 Left, Up
    Sleep, 10

Re: Detect Chrome page loaded

Posted: 27 May 2021, 15:22
by boiler
You can't have spaces before and after the file path inside the quotes. They become part of the string it's checking for.

Code: Select all

While !FileExist(" C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments.csv ")
Should be:

Code: Select all

While !FileExist("C:\Users\jpyle\Downloads\CustomerAssignments\CustomerAssignments.csv")
All times are UTC-05:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/