+ Reply to Thread
Results 1 to 2 of 2

Excel/VBA/Internet Explorer

  1. #1
    Alex
    Guest

    Excel/VBA/Internet Explorer

    To whomever can help me!


    I have been trying to get data from a webpage for which I have to
    select items in a dropbox and click a button. I have tried to do so
    with the sendkeys command, but IE is not allowing me to control it that

    way.


    I have been researching thoroughly and I got some ideas that might
    work, but that I can't get to specifically load what I need.


    This is the basics of what I have:


    Set IExp = CreateObject("InternetExplorer.Application")


    With IExp
    .Visible = True
    .navigate (url1)
    Set ipf = IExp.document.all.Item("miforma")
    ipf.submit
    End With


    End Function


    The item "miforma" loads for one of the buttons, and I want it to
    select the one on top!


    If anyone can help, a sample url is
    http://www.supervalores.gov.co/web_v...s_inf_fin&Tipo....

    Here you can see, in the source code, thet miforma is an item that
    submits a form, but I cannot find the other one!


    Many thanks!
    Alex


  2. #2
    Forum Contributor
    Join Date
    12-11-2004
    MS-Off Ver
    2007
    Posts
    137
    Hello Alex

    I hope this link helps you


    http://www.excelforum.com//showthread.php?t=370887


    Regards,
    michel

+ 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