Results 1 to 3 of 3

Button Refreshing Web Query Error

Threaded View

dteresinski Button Refreshing Web Query... 01-04-2011, 10:52 AM
MarvinP Re: Button Refreshing Web... 01-04-2011, 11:09 AM
dteresinski Re: Button Refreshing Web... 01-04-2011, 11:44 AM
  1. #1
    Registered User
    Join Date
    12-15-2010
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Button Refreshing Web Query Error

    Im trying to pull in data from a website, a currency exchange rate website.

    Though when I open the document I get a Query Refresh window that pops up. I'd like to get rid of this pop up, and replace it with a button on one of my sheets. As well my query thats being imported currently, i'd like to be on a hidden worksheet, so no one can see it easily.

    Is this possible? I have a macro that can refresh the web query but it doesn't work with a hidden worksheet and still get the annoying pop up window upon opening the document.

    Sub ExchangeRateRefersh()
    
        Sheets("Website Import").Select
        Selection.QueryTable.Refresh BackgroundQuery:=False
    End Sub
    Last edited by dteresinski; 01-04-2011 at 11:44 AM.

Thread Information

Users Browsing this Thread

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

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