Home > Software engineering >  How to use VBA (or other tools) extract on a web page form data?
How to use VBA (or other tools) extract on a web page form data?

Time:09-28

Objective: to extract the site, hankou railway station of the calendar year water level value (http://yu-zhu.vicp.net)
Eventually hopes to get the hankou railway station of the calendar year water level value (include the date and the corresponding water level value)
Could you post code?
Before contact with EXCEL VBA, but did not contact with web knowledge, don't know where to start, hope someone instruct me

CodePudding user response:

The webbrowser control,
Open a webpage,
After opening with HTML objects, analyze,
Take out the form object, there is data,

CodePudding user response:

Use excel standard features

CodePudding user response:

First, you need to extract the data on the site, the data should be in the database, access database and then to calculate
  •  Tags:  
  • VBA
  • Related