Consulting

Results 1 to 2 of 2

Thread: VBA login to Intranet, opens another workbook and looses login session

  1. #1
    VBAX Newbie
    Joined
    May 2019
    Posts
    1
    Location

    VBA login to Intranet, opens another workbook and looses login session

    Hi All,

    I've got a workbook that runs a macro;
    1. Opens an Internet Explorer window
    2. Navigates to a login page on the local intranet
    3. Logs in
    4. opens another workbook and runs another macro which does ActiveWorkbook.RefreshAll and saves
    5. The original workbook then moves on to the next file


    Previously this worked fine then when some of the internet settings were changed and the homepage was set outside of our intranet the macro would work up to the point of opening another workbook. When it went to refresh all it would loose the login information and not be able to return data on the "ActiveWorkbook.RefreshAll", just returning "Username" & "Password".

    Has anyone else ever encountered this?

    Thanks,
    Dan

  2. #2
    VBAX Regular
    Joined
    Sep 2016
    Location
    CHENNAI
    Posts
    13
    Location
    Could you upload the file for reference?

Posting Permissions

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