hi, i have a vba code in excel which creates internet explorer and goes to a website takes some info then it needs to close, but somehow it does not close, just stays open, and when i close it the debug takes me to ie.quit whats wrong can anyone tell me?
dim ie as object
web="https://google.com"
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate web
Do Until ie.ReadyState = READYSTATE_COMPLETE: Loop
SendKeys "~"
Application.Wait (Now + TimeValue("0:00:05"))
ie.Quit
dim ie as object
web="https://google.com"
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate web
Do Until ie.ReadyState = READYSTATE_COMPLETE: Loop
SendKeys "~"
Application.Wait (Now + TimeValue("0:00:05"))
ie.Quit
