By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,335 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,335 IT Pros & Developers. It's quick & easy.

SendKeys Generates Error

P: n/a
I have a macro that uses the SendKeys function to send F9 - to auto save a
record.

The Application runs perfectly on many PCs, but on one I get the following
error.

SendKeys Action Requires the "Application Name" Add-in to be loaded
when OK is clicked, a message appears saying "Action Failed"

Does anyone know what Add-in is being referred to?

Thanks - AB
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ABinBoston wrote:
I have a macro that uses the SendKeys function to send F9 - to auto save a
record.

The Application runs perfectly on many PCs, but on one I get the following
error.

SendKeys Action Requires the "Application Name" Add-in to be loaded
when OK is clicked, a message appears saying "Action Failed"

Does anyone know what Add-in is being referred to?

Thanks - AB


Sendkeys is dangerous, there's no guarantee the keystrokes will go to
the application you want it to and it's possible for them to be
misdirected. I once used it for cuting and pasting, etc, worked well for
months until one day my keystrokes went into Explorer, made a mess in there.

I'm sure there's a macro command for saving a record, I couldn't tell
you what though as I don't use macros myself, only VBA.

--
This sig left intentionally blank
Nov 13 '05 #2

P: n/a
On 21 Jan 2005 16:26:08 GMT, ab********@aol.com (ABinBoston) wrote:
I have a macro that uses the SendKeys function to send F9 - to auto save a
record.

The Application runs perfectly on many PCs, but on one I get the following
error.

SendKeys Action Requires the "Application Name" Add-in to be loaded
when OK is clicked, a message appears saying "Action Failed"

Does anyone know what Add-in is being referred to?

Thanks - AB

Hi
Searching Google for "SendKeys Action Requires" produces quite a few
bug-like queries and articles some of which may answer your question.

Nobody here likes Sendkeys for the reason Trevor mentions, you have to
apologise if you mention it in an answer though it is such an obvious
way of driving a GUI application that someone should have allowed for
it!

It is possible to use windows messages to send a keystroke, or the
messages which this generates, to your own thread, but I don't know
of a debugged piece of vba code for this.
David

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.