I use Power Query to get data from Web as your steps in answer forum: Then I will get the result: What I did, I use Chrome as default browser and login the web with the password. Then I save the password in Chrome. Then I go to Excel and load data, first time I failed to get by using legacy From Web option. Web queries offer a handy way to import data from selected tables into a worksheet-but Excel isn't as accommodating as it should be, especially when it comes to parameters. These tricks will let.
I have a funamental earnings and valuation model spreadsheet that downloads stock data from a number of different websites via certain add-ins. One of the sites that it gets information from is investors.com, which requires a login before downloading stock information (not just price/volume/etc data, I get that easily from Yahoo). Problem is that you have to manually login through a web query each time, and this is the current instructions: 
Excel For Mac Web Query Example With Login And Password Page
- Go to 'Data' on the Menu bar, then 'Import External Data'
- Then go to 'New Web Query' and a web browser will open
- Navigate to www.investors.com and login clicking remember me
- Then exit from the query, now you can use this tab
Excel For Mac Web Query Example With Login And Password Free
Excel Web Query With Username And Password
My question is how can I automate the login via either a macro or VBA code to login based upon a user name in one cell (C1), and a password in another cell (C2)?
Thanks in advance for any help you can provide!