#1
|
|||
|
|||
http request truncates the data
When I run this (after setting the references) I only get the data for the 1870's)
Ive tried other methods async and the IE object but always get the same reduced data set. Im stumped. Maybe this site restrict data access or something? Private Sub cmdHTTP_Click() Dim xmlhttp As New MSXML2.ServerXMLHTTP60 Dim myurl As String myurl = "https://www.multpl.com/s-p-500-pe-ratio/table/by-year" xmlhttp.Open "GET", myurl, False xmlhttp.send Application.Wait Now + TimeValue("00:00:10") Do While xmlhttp.readyState <> 4 DoEvents Loop Debug.Print xmlhttp.responseText End Sub Last edited by bronc; 07-18-2021 at 03:04 PM. Reason: oops |
#2
|
|||
|
|||
solved:
The intermediate window apparently truncates the data! (I'm bound to admit I got solution from another forum ;-) Grateful tho for those who took time to look at it. Thanks. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to open http link | YounesB3 | Excel | 1 | 11-13-2017 07:54 AM |
Transition of PowerPoint presentation to http | janinamilica | PowerPoint | 0 | 03-01-2017 07:58 AM |
http/1.0 404 not found | Powerpoint User | PowerPoint | 2 | 11-20-2016 11:10 PM |
Outlook http server | joelwelford | Outlook | 0 | 09-07-2015 10:00 AM |
Cannot click HTTP links in Office 2003 w/ IE8 | CntdwnToExtn | Office | 0 | 06-24-2010 09:07 AM |