ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Frastrating-doesn't give all the data (https://www.excelbanter.com/excel-programming/438486-frastrating-doesnt-give-all-data.html)

Southern at Heart

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?

joel[_559_]

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



All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com