After if fire this event Excel doesn\'t always wait long enough for the event to complete - I put in a dumb loop to "usually" works, but I know there\'s a correct way to do this. Any ideas? \r\n \r\nie.document.getElementById("ctl00_ctl00_cphMain_cphMain_ddlReceiveBran ch").fireevent ("onchange") \r\n \r\n\'WHAT I\'M USING \r\n For dumb = 0 To 100000 \r\n DoEvents \r\n Next \r\n \r\n\'THESE DON\'T WORK... \r\n Do While ie.busy \r\n DoEvents \r\n Loop \r\n \r\n Do While ie.ReadyState <> 4 \r\n DoEvents \r\n Loop
After if fire this event Excel doesn't always wait long enough for the event to complete - I put in a dumb loop to "usually" works, but I know there's a correct way to do this. Any ideas?
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET. subscribe