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/servlet/DisplayRates?show=&partner=8&hotl_id=421725&type=a book&filter=&splurgeUrl=/europe/united_kingdom/england/south_east/bracknell_e1.htm&*txtArrivalDate1=17-Apr-2006*&*txtDepartureDate1=18-Apr-2006*&locationID=450210&hotel_name=&lastLocation=B racknell&cboArrivalMonths=Apr-2006&cboArrivalDays=10&cboNights=03&number_of_adul 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
--
gunny197
-----------------------------------------------------------------------
gunny1979's Profile:
http://www.excelforum.com/member.php...fo&userid=3293
View this thread:
http://www.excelforum.com/showthread.php?threadid=52756