How can I automaticaly extract data from web pages into excel?

Question

I would liek to easily prepare creiteria for searching specific web pages and gathering data into an excel spread sheet .
example : collect prices of auctions that end at specific times and put them on a Spread sheet , extract stock value at specific times , automaticaly sort my helth test results in a spread sheet .. etc etc etc .. please help (can this be doen via VS in ecxel ? can VB script in excel get web pages and parser them ?)

Answer 1

yes.. this can be done... but i would like to know ur exact requirement.

can you message me at [e-mail]

or why dont u just visit www.ExcelGoodies.Com and then click on chat button there.. You would find some real excel experts online to help you on this.. May be u can give them a try.. its worthit

Answer 2

I don't know that this completely answers your question, but if you can get the data in a form that looks like a table, you should be able4 to cut-and-paste directly into Excel.

However, if you are looking to add new data to a spreadsheet over time (like the Stock Market example), then you will need a mechanism to collect the data and feed it into a file somewhere.

I wonder if Yahoo's new Pipes service (http://pipes.yahoo.com/pipes/) could help? The limitation is that the source data would need to be some kind of data feed, rather than a web page.

Answer 3

You will need a macro to do it.
Excel can read ASCII text files (Which is the same type of webpages) as HTML files, and get the values you want

MMMMM, you should have some knowledge in Excel / VBA / and HTML to do this

Enjoy my profile, I am the VBAXLMan