PDA

View Full Version : IE.navigate not working on VPN



30knotwind
04-06-2014, 08:50 PM
My code has been working for a full year on XP, MSIE8, Cisco AnyConnect (VPN). We recently migrated to Win7 and did not have trouble to begin with, but after a couple months it now never works on the VPN. It is giving me this error:

"The Object Invoked has disconnected from its clients" when it reaches the Do loop.

If I take out the Do loop, it gives me the same error when it gets to the next line of code, which inserts data into a form on the webpage.

The code always works without issues when I am off the VPN.

I have tried everything from lowering security settings to saving passwords, etc.

Any help appreciated!
Chris

Code:

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

'webpage to be edited
comment_url = ActiveWorkbook.Sheets("Comment").Range("M24").Value

IE.Navigate comment_url 'load web page

Do
DoEvents
Loop Until IE.readyState = 4

' READYSTATE_UNINITIALIZED = 0
' READYSTATE_LOADING = 1
' READYSTATE_LOADED = 2
' READYSTATE_INTERACTIVE = 3
' READYSTATE_COMPLETE = 4

Call IE.Document.getElementById("edit-field-trader-open-0-value-datepicker-popup-0").SetAttribute("value", pos_date)

westconn1
04-08-2014, 03:18 AM
try making the IE object visible, so you can see what is going on in the browser

Dave
04-08-2014, 09:45 PM
Trial going to your internet options setting (security) and disabling the protected mode. You also may have a registry problem that needs fixing. HTH. Dave