In case you still want to use the sendkeys functions (I agree tha
controlling IE from excell is better), here's how I avoided the error:

Sub TryIt()
Dim ieAlphaTrade, ieAmeritrade As Double

ieAlphaTrade = Shell("C:\Program Files\Internet Explorer\iexplore.exe"
vbNormalFocus)
On Error Resume Next
Do
Err.Clear
AppActivate ieAlphaTrade, True
Loop Until Err.Number = 0
End Sub



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26634