Easy One

[kwill]

How do I appactivate Internet Explorer from VBA?

 

[jitter]

AppActivate "Microsoft Internet Explorer"

 

[kwill]

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?

 

[jitter]

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.

 

[kwill]

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} ~&quot
'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