simulate pressing CTRL and A
 

hi,

how do you simulate pressing CTRL and A at the same time? would you use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee

simulate pressing CTRL and A
 

Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee

simulate pressing CTRL and A
 

hi,

well this is being done while in an IE window. i used the following to
simulate hitting ENTER key:

Windows.Application.SendKeys "{ENTER}"
SendKeys "{ENTER}"

so i am afraid cells.select will not work within the IE window. is there a
more specific sendkeys code?

thanks in advance,
geebee


"Jim Thomlinson" wrote:

Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee

simulate pressing CTRL and A
 

Try using "^A" as the argument to the SendKeys method (which is covered in
the help files for SendKeys by the way).

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

well this is being done while in an IE window. i used the following to
simulate hitting ENTER key:

Windows.Application.SendKeys "{ENTER}"
SendKeys "{ENTER}"

so i am afraid cells.select will not work within the IE window. is there
a
more specific sendkeys code?

thanks in advance,
geebee


"Jim Thomlinson" wrote:

Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you
use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee

simulate pressing CTRL and A
 

hi,

i am now using...


Windows.Application.SendKeys ("^A")
SendKeys ("^A")

its not giving me an error message, but at the same time it is not doing
anything either. im not sure what going on. any ideas? is there a more
dependable method?


thanks in advance,
geebee


"Rick Rothstein" wrote:

Try using "^A" as the argument to the SendKeys method (which is covered in
the help files for SendKeys by the way).

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

well this is being done while in an IE window. i used the following to
simulate hitting ENTER key:

Windows.Application.SendKeys "{ENTER}"
SendKeys "{ENTER}"

so i am afraid cells.select will not work within the IE window. is there
a
more specific sendkeys code?

thanks in advance,
geebee


"Jim Thomlinson" wrote:

Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you
use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee

simulate pressing CTRL and A
 

I've not done much (read that as nearly nothing) with web interfacing, so I
can't answer your question directly... I was only responding to your stated
SendKeys question itself. Hopefully someone with experience using IE
interaction will come along and address your problem.

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

i am now using...


Windows.Application.SendKeys ("^A")
SendKeys ("^A")

its not giving me an error message, but at the same time it is not doing
anything either. im not sure what going on. any ideas? is there a more
dependable method?


thanks in advance,
geebee


"Rick Rothstein" wrote:

Try using "^A" as the argument to the SendKeys method (which is covered
in
the help files for SendKeys by the way).

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

well this is being done while in an IE window. i used the following to
simulate hitting ENTER key:

Windows.Application.SendKeys "{ENTER}"
SendKeys "{ENTER}"

so i am afraid cells.select will not work within the IE window. is
there
a
more specific sendkeys code?

thanks in advance,
geebee


"Jim Thomlinson" wrote:

Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you
use the
SendKeys method? If so I am not sure of the code? If not, any
ideas?

thanks in advance,
geebee