simulate pressing CTRL and A

[geebee]

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

 

[Jim Thomlinson]

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

 

[geebee]

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

 

[Rick Rothstein]

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

 

[geebee]

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]

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.