Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data form website
Hi, I have finally managed to work out hoe to navigate to a website entering into the websites listboxes!!! Now all I need to do is to import the data I have navigated too, here is the macro I have so far can someone help me please!! Sub HiltonBracknell() Dim ie As Object Set objWSS = CreateObject("WScript.Shell") Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = True .navigate "https://www.hilton.co.uk/Reservation/300_CheckAvailability.jsp?hid=11001804" Do While .busy: DoEvents: Loop Do While .ReadyState < 4: DoEvents: Loop With .document.Forms("checkavailabilityform") .Day1.Value = "12" .monthYear1.Value = "200604" .Day2.Value = "13" .monthYear2.Value = "200604" .submit End With End With End Sub -- gunny1979 ------------------------------------------------------------------------ gunny1979's Profile: http://www.excelforum.com/member.php...o&userid=32932 View this thread: http://www.excelforum.com/showthread...hreadid=529161 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data form website
Hi Don, Thanks for this, but I dont undertand where I put this?? I hvae the macro to navigate through several webpages to get to the one I want, I am after a code to paste the data from the end website to excel!! Kev -- gunny1979 ------------------------------------------------------------------------ gunny1979's Profile: http://www.excelforum.com/member.php...o&userid=32932 View this thread: http://www.excelforum.com/showthread...hreadid=529161 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Saving data to a form datasheet | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data Form Deletions | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) |