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
Bookmarks