| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SendKeys with enter
hi all
i'm trying to use SendKeys to simulate rutine action. i'm doing the actions on web based system but from some reason after using the enter in the sendkeys the rest of the actions are not working this is the code Dim i, J As Long Range("A1").Select While Selection.Font.ColorIndex = 4 Selection.Offset(1, 0).Select Wend Selection.Font.ColorIndex = 4 i = Selection.Cells SendKeys "%{TAB}", True SendKeys "{DEL}", True SendKeys i, True SendKeys "{ENTER}", True SendKeys "{TAB}", True SendKeys "{TAB}", True SendKeys "{TAB}", True SendKeys "{TAB}", True SendKeys "{TAB}", True thank you for any advice |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendKeys with enter
Try inserting a DoEvents command immediately after the
SendKeys "{ENTER}", True -- Gary''s Student - gsnu201002 "thread" wrote: hi all i'm trying to use SendKeys to simulate rutine action. i'm doing the actions on web based system but from some reason after using the enter in the sendkeys the rest of the actions are not working this is the code Dim i, J As Long Range("A1").Select While Selection.Font.ColorIndex = 4 Selection.Offset(1, 0).Select Wend Selection.Font.ColorIndex = 4 i = Selection.Cells SendKeys "%{TAB}", True SendKeys "{DEL}", True SendKeys i, True SendKeys "{ENTER}", True SendKeys "{TAB}", True SendKeys "{TAB}", True SendKeys "{TAB}", True SendKeys "{TAB}", True SendKeys "{TAB}", True thank you for any advice . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| application.sendkeys shift+ctrl+enter | Excel Programming | |||
| F2 + <enter without sendkeys? | Excel Programming | |||
| SendKeys {Enter} acts like Return rather than Enter | Excel Programming | |||
Linear Mode
