SendKeys

[ankur]

Dear All,

I wish all the forum members a great New Year...

Could anyone tell me what are sendKeys used for and what are they?

Also it wud be great if someone answers the following...

where to find a list of the sendkeys parameters.

In particular send the keys (CTRL S) to save.


Thanks
Ankur

 

[Guest]

Ankur,

SendKeys sends one or more keystrokes to the active window as if typed at
the keyboard.

Look in Excel VBA help under:

SendKeys Statement
SendKeys Method

of details and the parameters.

 

[ankur]

Martin,

Yes it did help.

Thanks a lot for your help.

Regards
Ankur

 

[Chip Pearson]

SendKeys is quirky and unreliable. I would never use it in a commercial
application.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Guest]

The other keyboard controls can be found by typing "Keyboard Shortcuts" in
the Help search box of both Excel and VBA. You will find that there are many
combinations of keys that can do many functions. You have to be careful when
you use them, because some of them do different things in different
views/panes.

 

[Don Wiss]

SendKeys is quirky and unreliable. I would never use it in a commercial
application.

The only place where I find SendKeys to be useful is after the user has
clicked a Control Toolbar check box. Sending an Escape sends the focus back
to where ever it was before.

Don <www.donwiss.com> (e-mail link at home page bottom).