Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I place a 'pause' using sendkeys?
My problem is this - I need to copy a frame containing data from a web page and paste it into a particular worksheet in Excel then return to the start worksheet to begin the routine again. Sendkeys works fine up to the point of pasting, but the code executes in an order different from the order in which it was written and returns to the start sheet and executes before the paste - so the table is incorrectly pasted into the start sheet. I've tried 'slowing' the routine down by adding some 'go to's' and sendkeys "{TABS}" after the paste but it makes no difference - the code still executes in the wrong order. Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Make visual basic truely visual! | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |