readystate_complete

  1. C

    VBA to wait until IE webpage finishes loading before running the next step

    Hi, So the below is supposed to OPEN internet explorer, WAIT UNTIL IT LOADS, add username & password and click login, THEN WAIT AGAIN UNTIL THE PAGE LOADS and then many other clicks on hyperlinks, but up to here is enough to show my issue. So far I've been using "Application.Wait Now +...
  2. M

    VBA Macro question

    Hi there, I need help on the below code: the way this should work is I will list shipment #'s on the excel sheet1 and by running the macro it open the web browser go to the website that I list, then it goes to a particular field and add 5%, this macro is currently working but it only works on...
  3. U

    Not Working VBA to log into Website

    I am attempting to log into a website in efforts to pull data. The Code I have pasted below, does not work for my application. If I am to change the website to gmail it will run without error. This code will open the log in page, and then errors out at: "Loop Unti oBrowser.readyState =...
  4. M

    Going from IE to Google Chrome.

    I am trying to change my code from IE to Google Chrome and I am getting stuck on the ready state. Option Explicit Const MyUserName As String = "ABCOFA" Const MyPassword As String = "******" Const dayfrom As String = "12/01/2015" Const READYSTATE_COMPLETE As Integer = 4 Dim chromePath As...
  5. F

    Do While .Busy Or .readyState <> READYSTATE_COMPLETE

    Ive been doing alot of web scraping projects the last couple of months this is the line i'm usually using the first code below but its really unstable i think With IE Do While .Busy Or .readyState <> READYSTATE_COMPLETE DoEvents Loop End With Many times...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top