Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export html to exel

Status
Not open for further replies.

bugeditor

Technical User
Oct 9, 2001
44
0
0
IN
Hi,
I have lot of html Pages of different formats say with list of company names/addess/email etc etc..in tabular format and some non tabular

can anybody tell me how to export html data to exel sheet.


Do I need to write a program in VBscript to open this as text file and find match tags and insert into exel sheets

OR is there is another best way to export html to exel sheet

or do we have any utility to customise for our needs

Please anybody let me know


Thanks
 
Here's something you might find useful. On the user's part, it requires pushing one button, and then pressing CTRL-V to put the data into Excel...

Not exactly completely automated, but works very well for me.

faq216-738

hope that helps! :)
Paul Prewett
penny.gif
penny.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top