| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you reset the position that pressing CTRL-END moves you to? | Excel Discussion (Misc queries) | |||
| simulate pressing enter not working | Excel Programming | |||
| How to catch Ctrl+P short or Pressing Print Button | Excel Programming | |||
| Pressing ctrl (Excel - selecting cells) causes mouse to freeze..? | Excel Discussion (Misc queries) | |||
Linear Mode
