Hi,
I have a piece of codes to update stock price in an Access application,
Set a = CreateObject("InternetExplorer.application")
linkURL = "
http://finance.yahoo.com/q/ks?s=" & _
Replace(Trim(txtTickerSymbol.Value), " ", "")
DoCmd.Hourglass 0
a.Navigate ("" & linkURL & "")
Do While a.ReadyState <> 4
Sleep 100
Loop
My problem is, out of 8 users, only 1 occasionally hang on this call. I can release it by going into Windows Task Manager -> Processes and kill the hang IE instance.
Is this an IE issue? They use IE 6 on WinXP Pro.
Thanks,
~Sheldon