+ Reply to Thread
Results 1 to 3 of 3

IE Wait for Page Refresh

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    50

    IE Wait for Page Refresh

    Hi all-I've been working on this code for days now and can't seem to figure out how to get it right. Basically what I'm doing is using a website to look up weather data. VBA process is to copy values from worksheet to web page, submit the form to generate a new corresponding value and then paste the value back to worksheet.

    Please Login or Register  to view this content.
    Everything within the code works fine, except instead of returning the value after submitting the form it returns the original value from the web page.

    Any ideas on how to fix this would be greatly appreciated.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: IE Wait for Page Refresh

    Have tried repeating these lines in the code that wait for IE to be ready?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    50

    Re: IE Wait for Page Refresh

    Quote Originally Posted by Norie View Post
    Have tried repeating these lines in the code that wait for IE to be ready?
    Please Login or Register  to view this content.
    I just did, same result unfortunately.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Does VBA wait until pivot completes refresh?
    By cornel.i in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2016, 11:39 AM
  2. Wait until Refresh is done
    By pulsar777 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-30-2015, 02:29 PM
  3. [SOLVED] Wait for update (refresh not working)
    By jik_ff in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-18-2014, 10:33 AM
  4. Enable Auto Refresh - Wait for refresh to sinish before running a macro
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2011, 11:52 AM
  5. DataSource Refresh and wait
    By graeme86 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2008, 09:11 AM
  6. Wait until MSQuery Refresh finished
    By ChrisR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2005, 01:05 PM
  7. [SOLVED] Wait for Pivot Refresh to Complete
    By Dan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1