Well, that's what I thought too and it does flash for a very brief moment. However, it relenquishes the focus. I've also tried the "wait" tag with no luck. Anymore ideas?
Do you have any code following the appactivate that is forcing it to return to your app? You could paste any relevant code here to see what is going on.
I'm stepping thru, so it's not getting to another step, but this might help. Let me know what you think.
ActiveCell.Offset(rowoffset:=1).Select
'copy cell h2
ActiveCell.Copy
'activate IE
AppActivate "microsoft internet explorer"
'sendkeys alt, e, f, paste, enter, esc to find the sn
SendKeys ("%e f ^v {esc} ~"
'sendkeys shift+tab, spacebar to select radiobutton for row
'17 tabs to get to edit
'spacebar to edit
'appactivate excel
'copy edi#
ActiveCell.Offset(columnoffset:=1).Copy
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.