Copy table rows from HTML (VBA/Excel/ 2000+)

Topic

New Reply

I am lost attempting to copy rows x through y of an HTML table so that I can paste them into Excel. Can anyone help me with a snippet?

T.I.A.

Reply | Quote

Replies

Are you automating IE to retrieve the page, or are you using a control in a userform, or is it an Excel web query?

Reply | Quote

I’m using Excel VBA to open a query in the lounge, then selectively capture the returned table, I am adapting the code which you provided here.

Reply | Quote

So in that thread, IE opens and VBA uses the MSHTML library to read the structure of the document, including walking through the rows/cells in a table. Using that approach, of course, you could transfer cell contents one at a time. If you want to use the clipboard, hmmm, I don’t know whether that actually is possible.

Reply | Quote

Thanks for the consideration Jefferson.

I will advise of my success–or failure.

Reply | Quote

Have you seen this page, after studying the url of a search page you might use it to create a dynamic web query base don a cell:
http://www.jkp-ads.com/articles/webquery.asp%5B/url%5D

Reply | Quote

Thank you Jan Karel

I have some reading to do.

Reply | Quote