HTML to Excel Automation Script - TechRepublic
Question
September 10, 2008 at 11:13 AM
huck_splat

HTML to Excel Automation Script

by huck_splat . Updated 17 years, 10 months ago

I am looking for a script where you can enter an array of webpages which will then be converted into Excel friendly format, say xls or csv files.

This script will be run daily for multiple webpages from different sources. Even if script just pastes content into excel, would be easy to create site specific functions & macros to clean up the content.

Example would be ripping content from array of:

http://finance.yahoo.com/q/os?s=QQQQ&m=2008-09-19
http://finance.yahoo.com/q/os?s=QQQQ&m=2008-10-19
http://finance.yahoo.com/q/os?s=QQQQ&m=2008-11-19

Then placing all content in either individual workbooks/sheets which can be later manipulated in excel.

Hopefully I will be able to write such scripts on my own in near future, but I am not quite there yet (if you can point me to web resources with instructions to create such actions, also appreciated).

Thanks a bunch.

This discussion is locked

All Comments