Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frastrating-doesn't give all the data
in the example code below, why doesn't it return the whole source of the
webpage Function Get_Webpage(my_url As String) As Variant Set my_obj = CreateObject("MSXML2.XMLHTTP") my_obj.Open "GET", my_url, False my_obj.Send Get_Webpage = my_obj.responsetext Set my_obj = Nothing End Function Sub test() Dim strURL As String Dim strSource As Variant strURL = "http://www.gocomics.com/calvinandhobbes/2010/01/15" strSource = Get_Webpage(strURL) .... It's like it's truncated or something? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frastrating-doesn't give all the data
I found some notes at the MSDN website that said : Change GET ot POST POST works properly with multiple requessts to the same object. GE does not. So try POST when you experience problems -- joe ----------------------------------------------------------------------- joel's Profile: 22 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=17066 [url="http://www.thecodecage.com"]Microsoft Office Help[/url |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need two different data types to give me a total | Excel Worksheet Functions | |||
How to give a value to a range of data? | Excel Discussion (Misc queries) | |||
Is there a formula that I can use that will give the row data? | Excel Programming | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
can you count data in a cell to give a value? | Excel Worksheet Functions |