Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error - SendKeys in between a macro
Dileep wrote:
... SendKeys .. To debug SendKeys, I've done the following: replace Sendkeys "ABC", True (Don't you want True?) SendKeys "DEF", True with Call zSendKeys("ABC") Call zSendKeys("DEF") Sub zSendKeys(ps$) Dim t! Beep t = Timer + 5 ' 5 seconds to switch to application While Timer < t: DoEvents: Wend SendKeys ps, True t = Timer + 5 ' 5 seconds to look at action While Timer < t: DoEvents: Wend stop ' maybe End Sub You have to realize that switching windows may reset the field selected. D-C ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Error - SendKeys in between a macro | Excel Programming | |||
macro doesn't properly record AutoSum (and SendKeys doesn't work) | Excel Programming | |||
What's the syntax error with this SendKeys code? | Excel Programming | |||
Slow down SendKeys macro | Excel Programming |