How record each refresh?

C

cferoiu

I record this macro:

Sub Macro1()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://asianodds.org/next_50_games.asp",
Destination:=Range("$A$1"))
.Name = "next_50_games"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = False
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingAll
.WebTables = "5"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub

I whant to refresh this page at 3 min. interval, but I whant each refresh
record under one another, it is possible?
Any help appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Web query - unable to extract data 3
How do you importing unicode from web 2
Retrieving consecutive pages in web query What's wrong here? 1
help with prompt to pull wed address 1
How not to display any pop up message for macro? 4
some exotic error 5
VBA: Delete name range 3
Web Query Results to an Array 0

Top