+ Reply to Thread
Results 1 to 3 of 3

VBA to extract all HTML from *Already Open* IE session.

  1. #1
    Forum Contributor
    Join Date
    07-28-2008
    Location
    Leamington Spa, UK
    MS-Off Ver
    2010
    Posts
    142

    Question VBA to extract all HTML from *Already Open* IE session.

    Hi All,

    I would like to be able to extract HTML from a webpage and in fact I can....

    However the solution I have used previously relies upon opening Internet Explorer and navigating to the page URL. As we all know the URL doesn't neccesarily reflect what is on the screen at one time (some magic going on in the web world that I have not but a clue about!). For example if you go to a web page and it asks you for a variable for example your car reg number - click search - it isn't reflected in the URL however the data on the page has changed.

    To get round the above I want to first navigate manually in IE to my desired page, then click to run the macro in VBA from excel.
    The macro should look for an open session of IE and set focus to the open page.

    Hope all of that makes sense.

    It gets more complex if you have multiple IE sessions open and each contain multiple tabs but for now lets assume that there will only ever be 1 IE session open at one point and one tab within that session.

    I'm sure this is a simple one - I'm just useless at interacting with external apps from excel vba.

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: VBA to extract all HTML from *Already Open* IE session.

    http://www.mrexcel.com/forum/excel-q...lications.html - that might help

  3. #3
    Forum Contributor
    Join Date
    07-28-2008
    Location
    Leamington Spa, UK
    MS-Off Ver
    2010
    Posts
    142

    Re: VBA to extract all HTML from *Already Open* IE session.

    Brilliant - Thanks. Ill give it a try this afternoon.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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