+ Reply to Thread
Results 1 to 3 of 3

IE automation with VBA

Hybrid View

kiran527 IE automation with VBA 09-02-2013, 08:27 AM
kiran527 Re: IE automation with VBA 09-03-2013, 01:46 AM
kiran527 Re: IE automation with VBA 09-03-2013, 07:48 AM
  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    92

    IE automation with VBA

    Hi Guys

    i am trying to get the meta description from the web page but when i run the below code i am seeing a IE opened with text in address bar as
    "about:blank#http://www.google.com/"
    and it is not going forward..

    Could any body resolve this issue please...
    its very urgent.. i am breaking my head to get rid of this...
    Kindly help me

    Thanks in advance

    Function getMetaDescription() As String
    
    'Requires Early Binding Reference to MSHTML Object Library
    Dim html1 As HTMLDocument
    Dim html2 As HTMLDocument
    
    Set html1 = New HTMLDocument
    Set html2 = html1.createDocumentFromUrl("http://www.google.com", "")
    
    Do Until html2.readyState = "complete": DoEvents: Loop
    
    getMetaDescription = html2.getElementsByTagName("meta").Item("Description").Content
    
    Set html2 = Nothing
    Set html1 = Nothing
    
    End Function
    Last edited by kiran527; 09-03-2013 at 07:47 AM. Reason: Wants peoples attention

  2. #2
    Registered User
    Join Date
    10-30-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: IE automation with VBA

    Guys..........Anybody is there here to resolve this issue..... Kindly help..

  3. #3
    Registered User
    Join Date
    10-30-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: IE automation with VBA

    Any body is there to help

+ 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. IE Automation
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2011, 01:45 PM
  2. IE Automation
    By hodpy62 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2009, 01:10 PM
  3. need help in automation
    By najort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2009, 11:46 AM
  4. Automation??
    By Help in automation in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 09:15 AM
  5. [SOLVED] Automation
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2005, 03:06 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