Results 1 to 6 of 6

Getting Sendkeys to Send Keys

Threaded View

starcraftbud Getting Sendkeys to Send Keys 01-25-2011, 05:23 PM
shg Re: Getting Sendkeys to Send... 01-25-2011, 05:36 PM
starcraftbud Re: Getting Sendkeys to Send... 01-25-2011, 05:41 PM
starcraftbud Re: Getting Sendkeys to Send... 02-04-2011, 04:03 PM
shg Re: Getting Sendkeys to Send... 02-04-2011, 05:08 PM
starcraftbud Re: Getting Sendkeys to Send... 02-10-2011, 01:21 PM
  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    92

    Getting Sendkeys to Send Keys

    Hello,

    I'm working on a project and I'm looking to do some sort of send keys function. I got some VBA code from a friend but it doesn't seem to be doing anything.

    Here is the piece of code I have:
    SendKeys String:="%(1)"
    SendKeys String:="(C)"
    SendKeys String:="{ENTER 1}"
        
    SendKeys String:="%(1)"
    SendKeys String:="(L)"
    This does nothing. If I go through step by step, I see nothing happening.

    Here is what I am trying to do. The macro I have going adds some data to a sheet. We have a built in add-on in excel that I am trying to access once this data is available. The add-on is a menu bar that using alt and "1" opens. To put it simply, the code I put above is the correct keystrokes I want to send to continue the macro. I'm just not sure why its not working. It does not cause any VBA errors, the code just runs through it without performing any functions. I do not have vista and I am on excel 03. Thanks for any help, advice, or suggestions you guys have. The people contributing and adding insight or solving problems deserve more credit. Thank you.
    Last edited by starcraftbud; 02-04-2011 at 04:00 PM.

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