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!

Register Log in
  • 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!

Extract HTML Data Table into Excel without Query

Status
Not open for further replies.
bg18461

bg18461

Technical User
Mar 12, 2008
3
US
I am trying to extract a web table from an intranet website at work and paste into a worksheet in my current workbook. I was able to find a post that really helped me out with this, its shown below.


My only question is how to basically paste this into the active worksheet instead of creating a csv file. I would just like to find the table, copy and paste it into excel pretty much using the same code in the post above.
(Web Queries do not work on this website due to some security issues.)
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
255
remeng
remeng
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
525
strongm
strongm
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
394
strongm
strongm
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
587
remeng
remeng
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
204
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top