Using Auto-Refresh In Web Queries
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Using Auto-Refresh In Web Queries

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    When using auto-refresh in Excel 2000 to obtain updated external data from the Web, I would like to know if two things are possible.

    1) Can I limit the amount of time Excel spends in looking for the update? I would like the update to stop looking after 1 minute.

    2) Many times, I get an "Unable to Obtain Update" or “Unable to connect to URL” dialogue box. Is there a way to automatically hit the "ok" button on this dialog box? Excel seems to stop doing automated tasks when this dialog box appears, and since I'm away from the computer for long periods of time (15-30 minutes), I would like to get rid of this box automatically when it appears.

    Thanks for any response.


    Hios@interaccess.com

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    For your second question you can try using the code: application.displayalerts=false

    But I don't know if that will work for you.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    It really doesn't help, but thanks just the same.

    Any other ideas?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com