+ Reply to Thread
Results 1 to 10 of 10

Extract Complete HTML Source code of webpage

  1. #1
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Extract Complete HTML Source code of webpage

    Hi All,

    i am struck to get complete HTML source code from webpage, can anyone please help me out to get this done.

    this is my code

    Please Login or Register  to view this content.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Extract Complete HTML Source code of webpage

    can anyone please guide me if am missing keyword.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Extract Complete HTML Source code of webpage

    Me.TextBox1.Text = IE.document.body.innertext
    It might be the size of the text will not fit in the text, try to increase the size of text box.
    Why are you looping through all the windows though? Try one at a time.

  4. #4
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Extract Complete HTML Source code of webpage

    Hi Ab33

    Thanks its resolved,

    suppose if i want to extract source code without opening webpage i mean to say using MSXML2.XMLHTTP.6.0 then its not working when i used this its getting something different source code

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Extract Complete HTML Source code of webpage

    The response is different. it is not document, but is "responsetext"

  6. #6
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Extract Complete HTML Source code of webpage

    Hi AB33

    if i want to get complete HTML Source then how we can get ?

  7. #7
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Extract Complete HTML Source code of webpage

    Where is your code for MSXML2.XMLHTTP.6.0? If you have not got, please search this site or online. There are hundreds material on this method.

  8. #8
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Extract Complete HTML Source code of webpage

    HI AB33

    this is my code

    Please Login or Register  to view this content.

  9. #9
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Extract Complete HTML Source code of webpage

    I do not know the code you have, so I can not comment on it.
    This is the code I normally use. It works, but there is a limit to a display on debug. If you loaded in to text box you should be able to see the entire content.


    Please Login or Register  to view this content.

  10. #10
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Extract Complete HTML Source code of webpage

    Hi AB33

    Hmmm its okay, i tried a lot using XMLHTTP however document Source code not getting.

    I am using my first thread code.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-07-2016, 12:25 PM
  2. Pass entire HTML source for webpage to string using Excel VBA
    By stuht in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2013, 09:48 AM
  3. Help in getting to full HTML source code for webpage via Excel VBA
    By stuht in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2013, 05:41 PM
  4. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change)
    By bcbc123 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-11-2013, 11:39 PM
  5. Extract complete source code from IE
    By Edwar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2013, 01:42 PM
  6. extract information from webpage html tags to excel
    By b.hill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2012, 01:24 AM
  7. Reading HTML source code
    By Chinnick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2010, 03:38 PM

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