+ Reply to Thread
Results 1 to 2 of 2

sendkeys method not working!

  1. #1
    Registered User
    Join Date
    04-12-2015
    Location
    Wiesbaden, Germany
    MS-Off Ver
    2010
    Posts
    2

    sendkeys method not working!

    I am trying to hit enter automatically using the sendkeys method.

    However, it just doesn't work ... here are the different methods I tried ... none of these 4 methods worked:

    1.) Application.SendKeys "{ENTER}", True

    2.) Application.SendKeys "{~}", True

    3.) Call SendKeys("~", True)

    4.) Dim SKobj As Object
    Set SKobj = CreateObject("wscript.shell")
    Do While IEobj.Busy
    wscript.sleep
    Loop
    SKobj.SendKeys "{ENTER}", True

    I just don't understand why it is not working. Help would be much appreciated.

    P.S.: The reason why I have to use sendkeys is that hitting enter is the only method to start a search on the following website (the button next to the search box does not react):
    https://www.fitchratings.com/

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: sendkeys method not working!

    I haven't used sendkeys, but I can see where having it work on a different application can be problematic. At first, I thought it may only work within Excel, but then I found this example which shows it working with Notepad:
    http://www.java2s.com/Code/VBA-Excel...pplication.htm
    So, it appears you can use sendkeys to other apps, but you have to make sure it is the active application. Maybe you are already doing that...
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. [SOLVED] F2+Enter without sendkeys method
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-02-2015, 01:55 PM
  2. SendKeys not working for displaying filter dropdown list in excel 2007
    By kwhhyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2014, 09:12 AM
  3. SendKeys not working
    By maverick_abhi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2007, 12:29 AM
  4. Application.SendKeys stopped working
    By bondcrash in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-17-2007, 03:27 PM
  5. SendKeys not working from userform
    By Alfaholic in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-29-2007, 11:57 AM

Tags for this Thread

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