200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am trying to create a Macro to automatically download the contents of an Excel document into the current worksheet. My problem is the site requires company credentials to be entered before you can access the data.
Is there a way for Excel to use my current login session in the active browser so that there will be no need to enter the credentials into the Macro?
If you use internet explorer, or whatever the new version of that is now, then maybe you could do this if you are logged-in already through that browser, though I haven't tested this, so give that a try and see how it works. I'm not sure how well Excel can talk with the other browsers though.
Aside from that, you could also just use the below macro to login and make the password and email input through a simple inputbox or cells in a worksheet.
This macro can also help give you the framework for working with another browser, if that works the same as IE - I'd play around with it and see how far you can get.
Check out this macro and let me know how it works (its from here so you can copy/paste the code here or do whatever you'd like with it to test it out):
Login to a Website using a Macro
The macro has a lot of notes with it and I'm thinking that it could be the starting point for the macro that you use to pull-in the data.
