On analysis of the web site in question, the form variable names to login are htmUserName and htmPassword.
In this case, the primary task is to replace the three constants like:
VBA Code:
Const MyUrl As String = "http://www.investors.com/login.aspx?/default.asp" Const PostUser As String = "htmUserName=User Name" 'Change user name here Const PostPassword As String = "&htmPassword=password" 'Change password here
Note that, you may be able to change the URL and add more variables in order to download the data in one step without having to first login.
