Consulting

Results 1 to 3 of 3

Thread: IE.navigate not working on VPN

  1. #1

    Question IE.navigate not working on VPN

    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)

  2. #2
    try making the IE object visible, so you can see what is going on in the browser

  3. #3
    VBAX Expert Dave's Avatar
    Joined
    Mar 2005
    Posts
    835
    Location
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •