This is my web query which I update every day by changinig date on web site.
I recorded a macro and only thing that changes every day is date
Now, my question is can I automaticly change the date by importing it from the specific cells, concrete, in the user interface in first workbook I have 3 cells in which user can choose day month and year
Please help!
Sub zagreb()
'
' zagreb Macro
' Macro recorded 4.12.2008 by Marin Cerjan
'
'
Sheets("Sheet2").Select
Cells.Select
With Selection.QueryTable
.Connection = _
"URL;[url]http://croatian.wunderground.com/history/airport/LDZA/2008/12/2/DailyHistory.html?req_city=NA&req_state=NA&req_statename=NA"
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "14,23"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Bookmarks