Automating a web query login to download data

Excel Help for Automating A Web Query Login To Download Data in Automating Data Analysis Tasks

Automating A Web Query Login To Download Data

Rate this: (2.8/5 from 16 votes)

	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: 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 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!
	Posted by kilo94 on 18 Dec 2006

Replies - Displaying 1 to 10 of 40

Order Replies By: Most recent | Chronological | Highest Rated

	Kudos to your service. Rate this: (3/5 from 1 vote) +1 right here.
	Posted by nikkil on 02 Mar 2012

	Automatic login Rate this: (3/5 from 1 vote) Hi, I receive a logon screen from whitch I can not right click to see the parameters required. Looks like a windows login screen. Can anyone help with this ? Regards Bernard
	Posted by Bernard W on 10 Feb 2012

	Automatic Downloading Rate this: (3/5 from 1 vote) 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. Thanks Abdul Jaleel
	Posted by abdulncr on 18 May 2011

	New code Rate this: (3/5 from 1 vote) I have discovered that site has changed, so I was able to import data adding "&log=1" as the third parameter.
	Posted by cctanaka on 10 May 2011

	Which version of Excel? Rate this: (3/5 from 1 vote) The original code works for us.  Perhaps you are using a version of Excel that we have not tested.  Which version of Excel are you using?
	Excel Business Forums Administrator
	Posted by Excel Helper on 09 May 2011

	Code did not work Rate this: (3/5 from 1 vote) 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?
	Posted by cctanaka on 09 May 2011

Download data from the web and paste into Excel Rate this: (3/5 from 1 vote) 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.

Posted by davenpos on 05 Mar 2011

No code solution to get any data from any website into excel and back Rate this: (3/5 from 1 vote) I have been having some of the same issues of trying to get unstructured data from web pages that require login and transactional navigation. Here is a free tool that i created that allows you to mark the data that you are inteterested on any web page and send it to excel. It also allows you to take any cell values from your spreadsheet and post them on any web service I am currently looking for excel users to help me try the Beta version and give feedback. If interested please email [email protected] Yoav

Posted by Yoavdembak on 07 Dec 2010

	set referer for web query Rate this: (3/5 from 1 vote) Now I think the variables userident and challenge aren't a problem any more. However, I need somehow to spoof the referer to login. I couldn't find a way to do that in a web query. Does anyone have an idea, please?
	Posted by AndemWue on 16 Oct 2010

	Typo3 Login Error Rate this: (3/5 from 1 vote) Does anybody have an idea how to login into a typo3 backend using excel? (like in 'savecall .de/typo3/backend') It uses these strange variables userident and challenge... I get the typo3 error: Error: This host address ("www.mypage.de") and the referer host ("") mismatches!
	Posted by AndemWue on 15 Oct 2010

Displaying page 1 of 5

Next