Hello. I have an Excel macro which opens the Excel files, refreshes all contents, saves and closes them. When I launch the macro, the following prompt appears once:
Connect to Intranet
User name
Password
Remember my password
OK Cancel
How do I mimic the login/password entry in VBA to eliminate the need to interact with the prompt?
Thanks
Connect to Intranet
User name
Password
Remember my password
OK Cancel
How do I mimic the login/password entry in VBA to eliminate the need to interact with the prompt?
Thanks