G
gunny1979
Hi Guys,
I have set-up a Macro that goes to a website to get a competitors rat
see below:
Sub getit()
myurl
"http://www.all-hotels.com/xbook/ser...ts1=2&number_of_children1=0&number_of_beds1=1"
Wit
ActiveWorkbook.Worksheets("Bush").QueryTables.Add(Connection:="URL;"
myurl, Destination:=Worksheets("Bush").Cells(1, 1))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
As you can see by the bold type the URL contains a date!
Is ther any way I can amend this if a enter a date into a cell i
excel.
Your Help would be gratefully appreciated.
Regards
Kevin Gun
I have set-up a Macro that goes to a website to get a competitors rat
see below:
Sub getit()
myurl
"http://www.all-hotels.com/xbook/ser...ts1=2&number_of_children1=0&number_of_beds1=1"
Wit
ActiveWorkbook.Worksheets("Bush").QueryTables.Add(Connection:="URL;"
myurl, Destination:=Worksheets("Bush").Cells(1, 1))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
As you can see by the bold type the URL contains a date!
Is ther any way I can amend this if a enter a date into a cell i
excel.
Your Help would be gratefully appreciated.
Regards
Kevin Gun