https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474425#M71917 <PRE><CODE class=" language-jsl">POST: http://excalc.icfqs.com:7616/TQLEX?Entry=HQServ.hq_nlp HTTP/1.1 Host: excalc.icfqs.com:7616 Proxy-Connection: keep-alive Content-Length: 85 Origin: http://excalc.icfqs.com:7616 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 Content-Type: text/plain Accept: */* Referer: http://excalc.icfqs.com:7616/site/tdx-zbfx/page-detail.html?setcode=1&amp;code=688262&amp;name=%E5%9B%BD%E8%8A%AF%E7%A7%91%E6%8A%80&amp;color=0 Accept-Encoding: gzip, deflate Accept-Language: zh-CN,zh;q=0.9,en;q=0.8,zh-TW;q=0.7 Cookie: ASPSessionID= [{"funcId":1,"offset":0,"count":200,"cond":"code,1688262|INT,3","modname":"TickAly"}]</CODE></PRE> Wed, 30 Mar 2022 10:03:31 GMT lala 2022-03-30T10:03:31Z https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474424#M71916 <P>Hello, everyone!</P><P>The VBA can download data from this website.But I don't know how to change it to JSL to make it work.</P><P>Thank you very much!</P><PRE><CODE class=" language-jsl">Sub Post() Dim User_agent, Url_Post User_agent = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36" Url_Post = "http://excalc.icfqs.com:7616/TQLEX?Entry=HQServ.hq_nlp" Post_data = "[{""funcId"":4,""cond"":""code,1603969|"",""modname"":""TickAly""}]" With CreateObject("WinHttp.WinHttpRequest.5.1") .Open "post", Url_Post, False .SetRequestHeader "User-Agent", User_agent .Send (Post_data) Debug.Print .Responsetext End With End Sub</CODE></PRE> Fri, 09 Jun 2023 18:14:48 GMT https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474424#M71916 lala 2023-06-09T18:14:48Z https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474425#M71917 <PRE><CODE class=" language-jsl">POST: http://excalc.icfqs.com:7616/TQLEX?Entry=HQServ.hq_nlp HTTP/1.1 Host: excalc.icfqs.com:7616 Proxy-Connection: keep-alive Content-Length: 85 Origin: http://excalc.icfqs.com:7616 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 Content-Type: text/plain Accept: */* Referer: http://excalc.icfqs.com:7616/site/tdx-zbfx/page-detail.html?setcode=1&amp;code=688262&amp;name=%E5%9B%BD%E8%8A%AF%E7%A7%91%E6%8A%80&amp;color=0 Accept-Encoding: gzip, deflate Accept-Language: zh-CN,zh;q=0.9,en;q=0.8,zh-TW;q=0.7 Cookie: ASPSessionID= [{"funcId":1,"offset":0,"count":200,"cond":"code,1688262|INT,3","modname":"TickAly"}]</CODE></PRE> Wed, 30 Mar 2022 10:03:31 GMT https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474425#M71917 lala 2022-03-30T10:03:31Z https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474429#M71918 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-03-30_18-05-06.png" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/41302i8531818AD783633A/image-size/large?v=v2&amp;px=999" role="button" title="2022-03-30_18-05-06.png" alt="2022-03-30_18-05-06.png" /></span></P> Wed, 30 Mar 2022 10:05:44 GMT https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/474429#M71918 lala 2022-03-30T10:05:44Z https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/475108#M71980 <P class=""><SPAN class="">VBA code, I just don't know how to change to JSL.</SPAN></P><P class=""><SPAN class="">Experts are invited to guide.</SPAN><SPAN class="">Thank you very much!</SPAN></P><PRE><CODE class=" language-jsl">Sub Post() Dim User_agent, Url_Post User_agent = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36" Url_Post = "http://excalc.icfqs.com:7616/TQLEX?Entry=HQServ.hq_nlp" Post_data = "[{""funcId"":4,""cond"":""code,1603969|"",""modname"":""TickAly""}]" With CreateObject("WinHttp.WinHttpRequest.5.1") .Open "post", Url_Post, False .SetRequestHeader "User-Agent", User_agent .Send (Post_data) Debug.Print .Responsetext End With End Sub</CODE></PRE><P class=""><SPAN class=""><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-04-01_15-24-01.png" style="width: 965px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/41382i357DC8B0D7A7B5E8/image-size/large?v=v2&amp;px=999" role="button" title="2022-04-01_15-24-01.png" alt="2022-04-01_15-24-01.png" /></span></SPAN></P> Fri, 01 Apr 2022 07:30:56 GMT https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/475108#M71980 lala 2022-04-01T07:30:56Z https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/475207#M71982 <P>Use JMP's http request, just like VB.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The octet stream means you need blobToChar conversion." style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/41411i450AAEB7CA7F67B2/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.PNG" alt="The octet stream means you need blobToChar conversion." /><span class="lia-inline-image-caption" onclick="event.preventDefault();">The octet stream means you need blobToChar conversion.</span></span></P> Fri, 01 Apr 2022 15:01:15 GMT https://community.jmp.com/t5/Discussions/How-to-change-the-VBA-of-excel-to-JSL-in-order-to-download-data/m-p/475207#M71982 Craige_Hales 2022-04-01T15:01:15Z