I have a macro that i have a few problems with. Idea is i give it a link, it opens IE in the background and copies information from the page onto a new sheet in the workbook. I have it on 5 computers and it works perfectly on three. All have the same OS, IE version and Office version. My porblem is with my laptop. the piece of code im stuck with is
this is suppose to create an IE application, set it to be invisible and open a link.
what actually happens is it creates a IE application then a visable window comes up and the macro gets stuck in the loop waiting for the page to load.
Why does this happen on my Laptop and not the other four computers?
Code:
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = False
ie.navigate link
'Wait for initial page to load
Do While ie.Busy Or Not ie.readyState = IE_READYSTATE.complete: DoEvents: Loopthis is suppose to create an IE application, set it to be invisible and open a link.
what actually happens is it creates a IE application then a visable window comes up and the macro gets stuck in the loop waiting for the page to load.
Why does this happen on my Laptop and not the other four computers?
