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