+ Reply to Thread
Results 1 to 5 of 5

macro of internet explorer

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Cool, philippines
    MS-Off Ver
    Excel 2007
    Posts
    4

    macro of internet explorer

    Hi everyone,

    I would like to seek your assistance as I have seen your comments in some of the threads here.

    My question is, is it possible to navigate internet explorer using a macro in a way that the macro will do the clicking. Hope you could spend a couple of minutes answering my query. Thanks a lot.

    -ds

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: macro of internet explorer

    Hi dropshot,

    In VBA you could do a SendKeys command that puts keystrokes in the keyboard buffer just like you were typing them.

    Here is an example:
    http://www.daniweb.com/software-deve...s-in-excel-vba
    or search the web for VBA SendKeys
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    08-01-2012
    Location
    Cool, philippines
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: macro of internet explorer

    Thank you Marvin,

    How about clicking and item or link, is it possible? Thanks a lot again.

    -ds

  4. #4
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: macro of internet explorer

    I have to disagree with telling the OP to use SendKeys, as it's unlikely to work reliably with IE, or any application for that matter.

    Instead search for IE automation with the HTML Object Library, which allows you navigate IE to URLs, click links, populate form fields, click buttons, etc.
    Post responsibly. Search for excelforum.com

  5. #5
    Registered User
    Join Date
    08-01-2012
    Location
    Cool, philippines
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: macro of internet explorer

    Hi guys,

    I really appreciate your help. Please advise on how could I do it. Thanks.

    -ds

+ 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