-
VBA login to Intranet, opens another workbook and looses login session
Hi All,
I've got a workbook that runs a macro;
- Opens an Internet Explorer window
- Navigates to a login page on the local intranet
- Logs in
- opens another workbook and runs another macro which does ActiveWorkbook.RefreshAll and saves
- 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
-
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
-
Forum Rules