Consulting

Results 1 to 8 of 8

Thread: IE VBA controls

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    IE VBA controls

    Hello all,
    I am trying to automate a series of repetitive commands from a web application. So I would very much appreciate it if someone can follow this through with me.
    I got as far as opening a internet explorer though I would need to know the vba commands to navagate through the website(i.e. type in search box, selecting scroll down menu...etc)
    Please see below for details and advise.
    Many thanks

    Regards,
    Ed

    Sub Google()
    Set ie = CreateObject("internetExplorer.application")
    'Set objshell = creatobject("wscript.shell")
    With ie
    .Navigate http://google.com/
    .Visible = 1
    End With

    'wait a while until IE as finished to load
    Do While ie.Busy
    DoEvents
    Loop



  2. #2
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Ed

    What details?

    For this sort of thing they are essential.

    And it's not really VBA you should be worrying about but how the particular site you are trying to work with is designed.

  3. #3
    thanks for the prompt response Norie.
    If we are working with the website bleow. I would be greatful if you will be able to tell me the vba codes to search and navagate the site. I get the feeling that one will need to correspond the commands to the HTML codes of the site.
    Please advise, many thanks
    http://www.independent.co.uk/

    Regards,
    Ed

  4. #4
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Ed

    Yes we would need to know the HTML code, but I think we would also need a little more detail.

  5. #5
    Let start of with the site below
    http://metro.co.uk

    and search for the below in search box
    "Little green 'naked' alien "

    click on the first entry under weird titled
    1 Little green 'naked' alien discovered on Mars

    Thanks Norie =)

    Regards,
    Ed

  6. #6
    Any news guys?
    regards,
    Ed

  7. #7
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Ed

    Yes, there's 1562 lines of HTML code on that page and I'm afraid I've not got the time to go through it all.

    Try a board search - there are examples of this sort of thing out there.

  8. #8
    thanks for the respose though I was really only asking for general instructions.
    I would appreciate it if you can point me to the right direction with a couple if links perhaps.
    many thanks

    regards,
    Ed

Posting Permissions

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