Getting Sendkeys to Send Keys

**starcraftbud** · 01-25-2011, 05:23 PM

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.

**shg** · 01-25-2011, 05:36 PM

If you built the add-in, why not just call whatever procedure you need directly?

**starcraftbud** · 01-25-2011, 05:41 PM

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?

**starcraftbud** · 02-04-2011, 04:03 PM

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

**shg** · 02-04-2011, 05:08 PM

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

**starcraftbud** · 02-10-2011, 01:21 PM

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.