Trying to extract tables of data from an HTML document on th

ajr123 · Apr 6th, 2002, 10:29 AM

I currently am trying to copy or extract tables of data using VBA to either link or copy back into excel. Does any have a simple bit of code they can share on this?
Thanks

Tom Schreiner · Apr 6th, 2002, 12:35 PM

This is not my area of expertise. I actually have no areas of expertise, but this is what I would do for myself...
Creat a web query while recording a macro and look closely at the syntax. There are options for importing selective tables from a website. It is not always obvious as to which table is what. Right click on your web page and choose view source and search the html code for tables... Play around with it...
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 10:29 AM	#1
ajr123 New Member Join Date: Apr 2002 Location: Adam Posts: 9	I currently am trying to copy or extract tables of data using VBA to either link or copy back into excel. Does any have a simple bit of code they can share on this? Thanks

Apr 6th, 2002, 12:35 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	This is not my area of expertise. I actually have no areas of expertise, but this is what I would do for myself... Creat a web query while recording a macro and look closely at the syntax. There are options for importing selective tables from a website. It is not always obvious as to which table is what. Right click on your web page and choose view source and search the html code for tables... Play around with it... Tom