Consulting

Results 1 to 2 of 2

Thread: Open web Page and clink on a link within the page

  1. #1
    VBAX Regular
    Joined
    Feb 2011
    Posts
    24
    Location

    Open web Page and clink on a link within the page

    Hi - This is the first time I post in this forum. I really need urgent help, I am struggling.

    I am sure my post and questions had been answered before, but still cant figure it out, maybe by posting my code and somebody modifies it to fit my need.

    As the title explains I need to click on a link within a webpage.

    As an example say I need to click on the word "Health" within YAHOO. I have the code below:

    Private Sub DrawingIn_Click()

    Set browser = CreateObject("InternetExplorer.Application")
    browser.Navigate ("YAHOO PAGE")
    browser.StatusBar = False
    browser.Toolbar = False
    browser.Visible = True
    browser.Resizable = False
    browser.AddressBar = False

    What lines of codes do I need to clck on the "Health" ?

    P.S I am using Excel 2007.

    Thank you very much.

  2. #2
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    Why not just navigate directly to the Health page?

    browser.navigate "http://health.yahoo.net/"
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

Posting Permissions

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