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

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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"ankur" wrote:



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

Martin,

Yes it did help.

Thanks a lot for your help.

Regards
Ankur

Martin Fishlock wrote:
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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"ankur" wrote:



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

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)


"Martin Fishlock" wrote in message
...
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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"ankur" wrote:



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

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.

"ankur" wrote:



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

On Sat, 30 Dec 2006 09:48:46 -0600, Chip Pearson wrote:

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).