Automating a web query login to download data

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

Find Excel Solutions


Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?




Follow Business Spreadsheets On:
 
Forum TopicReply Login

Automating A Web Query Login To Download Data

Rate this:
(2.8/5 from 16 votes)
Confused 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)?

Thanks in advance for any help you can provide! 
 Posted by on
 
Replies - Displaying 1 to 10 of 40Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
+1 right here.
 Posted by on
Surprised
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 on
Confused
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 on
Confused
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 on
Oops
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 on
Confused
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 on
ConfusedHi,
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 on
HappyI 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 on
Fedup
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 on
Sad
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 on
 Displaying page 1 of 5 

Find relevant Excel templates and add-ins for Automating a web query login to download data in the

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |