Closed Thread
Results 1 to 3 of 3

How to read heading structure of a web page through vba

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    Karachi, Pakistan
    MS-Off Ver
    Office 2007
    Posts
    6

    How to read heading structure of a web page through vba

    Hi All,

    I am trying to capture the heading structure of a given web page in the order they appear. For example, h1 appears first, then h2, h3, h3, h2, and so on. Similarly, their contents / text extraction is also required.

    I am using the MS HTML DOM methods like getelementsbytagname( ) as to my knowledge of this library but it requires tag name and if I hard code "h1", it will go and search wherever it is found and not in the sequence in which it appears in the page source.

    Thanks in advance.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: How to read heading structure of a web page through vba

    duplicate to http://www.excelforum.com/excel-prog...rough-vba.html - please place your answer in the other thread.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: How to read heading structure of a web page through vba

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to read heading structure of a web page through vba
    By fteach in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2014, 03:20 AM
  2. [SOLVED] VBA/Macro to detect a heading at the bottom of a page and create a page break
    By jdodz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2014, 07:16 PM
  3. Read column A get value from B put in another spreadsheet with cell name as heading
    By coolexcelforum1 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-10-2013, 11:35 PM
  4. Replies: 4
    Last Post: 04-26-2007, 02:13 AM
  5. [SOLVED] Heading at the top of page...
    By J5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2006, 06:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1