chaniging a date in a url!!

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
 
G

gunny1979

Hi I tried both of these and it does not like it, its there any othe
way I can try?
 
D

Don Guillett

There is no reason why it should not work if you did it properly. Feel free
to send me a copy of your workbook and I will have a look.
 

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

Run Time Error 1

Top