Data transfer from webpage to excel

5 pts.
Tags:
Microsoft Excel
I have a complicated problem for data extract from a web site. It is about a horse race analysis. problem description as below 1. want to retrieve some historical data and non-dynamic 2. datas are spread into many different web pages and they are in asp. 3. pull down menu is on the web page and have to select it for different date information 4. some image link is on page and have to select for different race per date. 5. only need a table inside the page. what have i done? 1. did copy and paste into excel file 2. very time consuming 3. use countif, sumif function in the excel file. my question, 1. is it possible to complete by automatically by VB script??, a. for involving automating select date in sequence, b. select race in sequence, c. and copy dedicated table into the spread sheet remark: link shows info of date and race nos. Many Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

As far as I know Excel allows you to directly import data from the Web anyway you may try and get the data and reformat it by using VBScript <a href=”http://www.activexperts.com/activsocket/howto/http/vbscript/”>here</a> are some examples

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following