![]() ![]() I am not sure how to get just the json data when you follow the link below, and or how to store it so that the problem experienced with URL 1 (missing data) does not occur. from the first URL I only want the JSON data which results from the YQL query. What is the best way to handle these requests so that all the data is captured and I can parse it all later? If I download the txt file from url 2 in notepad++ it has almost 200 000 charactersīut it excel it has between 3 -5 000. However these methods seem to be cutting off parts of the data? I thought I could simply store the result of these http requests and print it to the debug window or directly to a cell. Set XMLHTTP = CreateObject("WinHttp.WinHttpRequest.5.1") ![]() The program downloads stock market data from the asx. I am in the process of making a program I wrote using excel vba faster. ![]()
0 Comments
Leave a Reply. |