j********9 发帖数: 162 | 1 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. |
c**t 发帖数: 2744 | 2 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.
|
j********9 发帖数: 162 | 3 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. |
c**t 发帖数: 2744 | 4 use XMLHttp to retrieve....
can
【在 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.
|