Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2021, 03:02 PM
bronc bronc is offline http request truncates the data Windows 7 64bit http request truncates the data Office 2010 64bit
Novice
http request truncates the data
 
Join Date: Apr 2017
Posts: 5
bronc is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-21-2021, 11:49 AM
bronc bronc is offline http request truncates the data Windows 7 64bit http request truncates the data Office 2010 64bit
Novice
http request truncates the data
 
Join Date: Apr 2017
Posts: 5
bronc is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft