Hi, I am trying to use Excel VBA to get information from website. The data I need is in the pop-up windows. I tried to use web query, seems not working. Do you know is there any other way I can download it or there is some trick with web query? Thanks.
s*j
5 楼
Small lot as follows: 1911 Liberty Head V nickel, G-VG; 1912-D Liberty Head V nickel, full 7-letter Liberty, Fine; 1893-O Barber 50c, Fair; and 1894-S Barber 50c, Fair. Also one Whitman plastic holder for penny through half dollar.
c*t
6 楼
you need figure out what the url of the popup is; if unfortunatly it's pop div, you need parse out the html code...
trick
【在 j********9 的大作中提到】 : Hi, I am trying to use Excel VBA to get information from website. : The data I need is in the pop-up windows. I tried to use web query, seems : not working. : Do you know is there any other way I can download it or there is some trick : with web query? : Thanks.
g*n
7 楼
不值钱,别买
j*9
8 楼
Thanks for response. I eventually made webquery work for that url address. Now my question is can VBA control which button to push and send information out, then get the string of the returned URL? Basically can I use VBA to communicate with the web site, locate and download that webpage. How can I do that? Thanks again in advance.
【在 j********9 的大作中提到】 : Thanks for response. : I eventually made webquery work for that url address. Now my question is can : VBA control which button to push and send information out, then get the : string of the returned URL? : Basically can I use VBA to communicate with the web site, locate and : download that webpage. How can I do that? : Thanks again in advance.