Trying to extract tables of data from an HTML document on th
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

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

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Adam
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com