+ Reply to Thread
Results 1 to 2 of 2

View entire source code of website using Excel VBA

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    lONDON
    MS-Off Ver
    Excel 2003
    Posts
    1

    View entire source code of website using Excel VBA

    When I try to access the source code of

    http://www.mysupermarket.co.uk/sains...uliflower.html

    In Google Chrome I see less information than Internet Explorer when looking at it directly from my browser. I think maybe Chrome is focused on a particular element/frame/something else. Is there any Excel VBA code I can use to get exactly what I see on Internet Explorer as a string in VBA? Ideally without launching an IE session.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: View entire source code of website using Excel VBA

    Hello,

    the page looks identical to me in Chrome and IE11. What differences do you see?

    In any case, modern web sites like this use a lot of things behind the scene before the html is even generated. Based on your stored cookies, login status and other data mining techniques, there may be server side processing that determines what content is presented to a user. On top of that, client side Javascript will be used to further tune page presentation and show/hide elements. All these may differ per browser, cookies specifically. Getting to the bottom of that will be way more complex than viewing the rendered html.

    cheers, teylyn

+ 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. Pull Website Source Code with Selenium (PhantomJS) VBA
    By mattmc419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2015, 05:02 AM
  3. Importing website source code into excel
    By Schwizer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2013, 06:57 PM
  4. Macro to get source code from a website.
    By terbart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2013, 09:26 AM
  5. [SOLVED] How would I grab the source code from a website and place it into a text file using vba?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2012, 10:31 AM
  6. How to view entire drop down list in Excel 2007 (Win 7)
    By Sugartit in forum Excel General
    Replies: 3
    Last Post: 02-16-2011, 03:38 AM
  7. How to view website tags?
    By JRLats in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2009, 06:27 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