+ Reply to Thread
Results 1 to 6 of 6

Getting Sendkeys to Send Keys

  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:
    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Getting Sendkeys to Send Keys

    If you built the add-in, why not just call whatever procedure you need directly?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: Getting Sendkeys to Send Keys

    I didn't build the add-in. Nor do I have access to change it.

    I thought I had this figured out, but I didn't. The macro seems to run through this stretch of code without actually doing anything.

    It just continues to the next code. Any ideas or ways to make the send keys work?
    Last edited by starcraftbud; 02-04-2011 at 04:02 PM.

  4. #4
    Registered User
    Join Date
    02-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: Getting Sendkeys to Send Keys

    This has worked before or seemed to work. I don't run this very often, but today it gave me trouble again.

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Getting Sendkeys to Send Keys

    Do you have the source code for the add-in?

  6. #6
    Registered User
    Join Date
    02-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: Getting Sendkeys to Send Keys

    I do not have the source code. Is there a more effective method than simple "sendkeys"?

    I work at a large firm. I am not a "systems" person, and this add-on is supported by the company's IT department - which I would not have access to.

+ 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