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:
1. Go to "Data" on the Menu bar, then "Import External Data"
2. Then go to "New Web Query" and a web browser will open
3. Navigate to www.investors.com and login clicking remember me
4. Then exit from the query, now you can use this tab
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)?
Hi, After reading all these post, i tried, but is not working in my requirement . i want download Traffic fine from [http://www.rta.ae/wpsv5/wps/portal] -Fine Inquiry- put the Traffic File number(50086190) and click search and download. Could any one help me on this, it would be really appreciated.
I have copied and pasted the first VBA code (first I have created an account in business-spreadsheet site), but it did not worked. Data os site was transferred to Excel, but looking at H11 cell I noticed that it is written Login instead of logout, so login did not worked. Does VBA code really works for POST method?
Hi, I am trying to mak a macro to log in to [http://metflight.metra.co.nz/MetFlight.php] then once the pop up has loaded, select certain parameters, then from a following pop up window, copy and paste that data in excel. Can anyone help me? I have tried using a few different ways to just log in, but im struggling wth that.