Home > Forum Home > Automating Data Analysis Tasks > Automating a web query login to download data > Method will not work in all cases Share

Method will not work in all cases

Excel Help for Method Will Not Work In All Cases in Automating Data Analysis Tasks


Forum TopicLogin

Method Will Not Work In All Cases

Rate this:
(3/5 from 1 vote)
Angry The .Post method for automating web query login will not work in all cases. In the last post, we can see from the page source that the form is posted to an encypted page:

action='https://wwwa2.settrade.com/LoginRepOnRole.jsp'

This should be the target of the web query; however it will not work as the page is secured (https).

Another setback we have seen is the presence of a session variable required by the target page to authenticate the user.  We have provided a solution for this whereby the session variavble value is first obtained then sent back with the login credentials to automate the login.  This is not fully stable and some more thought is required to come up with a robust solution to this issue.

 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Method will not work in all cases in the