Detect Chrome page loaded

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
NewYears1978
Posts: 20
Joined: 09 Jun 2016, 07:44

Detect Chrome page loaded

27 May 2021, 13:02

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
Last edited by NewYears1978 on 27 May 2021, 14:15, edited 1 time in total.
User avatar
boiler
Posts: 17215
Joined: 21 Dec 2014, 02:44

Re: Detect Chrome page loaded

27 May 2021, 13:34

You can use ImageSearch to keep checking until the refresh icon that appears in its place appears.
User avatar
boiler
Posts: 17215
Joined: 21 Dec 2014, 02:44

Re: Detect Chrome page loaded

27 May 2021, 13:56

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.
NewYears1978
Posts: 20
Joined: 09 Jun 2016, 07:44

Re: Detect Chrome page loaded

27 May 2021, 14:15

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
User avatar
boiler
Posts: 17215
Joined: 21 Dec 2014, 02:44

Re: Detect Chrome page loaded

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")
NewYears1978
Posts: 20
Joined: 09 Jun 2016, 07:44

Re: Detect Chrome page loaded

27 May 2021, 14:55

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.
NewYears1978
Posts: 20
Joined: 09 Jun 2016, 07:44

Re: Detect Chrome page loaded

27 May 2021, 15:00

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
NewYears1978
Posts: 20
Joined: 09 Jun 2016, 07:44

Re: Detect Chrome page loaded

27 May 2021, 15:18

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

    
User avatar
boiler
Posts: 17215
Joined: 21 Dec 2014, 02:44

Re: Detect Chrome page loaded

27 May 2021, 15:22

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")

Return to “Ask for Help (v1)”

Who is online

Users browsing this forum: Bing [Bot], jacek678, sachalamp and 182 guests