Retrieve Web data login/Password

[Gregfox]

Hello all, I’m trying to use vba to retrieve data from the following web site;
https://www.smithbarney.com/cgi-bin/login/login.cgi
I’m using Excel 2007 and the code I have so far is…

Sub WebLogin()
Dim a As String
Set ie = CreateObject("InternetExplorer.Application")
With ie
.Visible = True
.navigate "https://www.smithbarney.com/cgi-bin/login/login.cgi"
Do Until .readyState = 4
DoEvents
Loop
.document.all.Item("username").Value = "MyUserId"
.document.all.Item("password").Value = "MyPassword"
.document.forms(0).submit
End With
End Sub

I went to the web page and clicked view source, but couldn’t determine which login and password I should put in the code. I think the problem is username and password not matching the source code.
Once I login to the web page I would like to import a page, then logout and close the page.
Thanks, Any help would be most appreciated.

 

[Ruddles]

I'm not 100% certain but it looks like the username and password boxes are both called the same and they're doing something tricky with them - swapping them around, maybe... possibly it's a security measure to prevent people trying to run login scripts.

It's got me beat.

 

[Gregfox]

Thanks for looking...

 

[Gregfox]

Can anyone help on this, I've tried for days...

 

[Joneye]

Try this little site, let me know how you get on...?

http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/

 

[Ruddles]

<!--< span class="input">< input type="text" title="Enter Password" id="password" name="password" value="Enter Password" onblur= "checkCopy(this)" onfocus='swapfield(this,"password")' onkeyup="return handleEnterSubmission( this.form , event)" maxlength="35" autocomplete="off" />< /span>-->
<!--< span class="input">< input type="text" title="Enter Password" id="password" name="password" value="Enter Password" onblur= "checkCopy(this)" onkeydown='swapfield(this,"password")' *******='swapfield(this,"password")' onkeyup="return handleEnterSubmission(this.form,event)" maxlength="16" autocomplete="off" />< /span>-->
Joneye, did you look at the HTML?

<!--< span class="input">< input type="text" title="Enter Password" id="password" 
name="password" value="Enter Password" onblur= "checkCopy(this)" 
onfocus='swapfield(this,"password")' 
onkeyup="return handleEnterSubmission( this.form , event)"  maxlength="35" 
autocomplete="off" />< /span>-->

<!--< span class="input">< input type="text" title="Enter Password" id="password" 
name="password" value="Enter Password" onblur= "checkCopy(this)" 
onkeydown='swapfield(this,"password")' *******='swapfield(this,"password")' 
onkeyup="return handleEnterSubmission(this.form,event)"  maxlength="16" 
autocomplete="off"  />< /span>-->
       
<!--< span class="input">< input type="text" title="Enter Password" id="password" 
name="password" value="Enter Password" onblur= "checkCopy(this)" 
onkeypress='swapfield(this,"password")' *******='swapfield(this,"password")' 
onkeyup="return handleEnterSubmission(this.form,event)"  maxlength="16" 
autocomplete="off"  />< /span>-->
 
< span class="input">< input type="text" title="Enter Password" id="password" 
name="password" value="Enter Password" onblur= "checkCopy(this)" 
onfocus='swapfield(this,"password")' onkeypress='swapfield(this,"password")' 
*******='swapfield(this,"password")' 
onkeyup="return handleEnterSubmission(this.form,event)"  maxlength="16" 
autocomplete="off"  />< /span>

I can't work out where the username is meant to go. I think the JavaScript is doing something cunning with the password, swapping it with the username 'somehow'.

 

[Joneye]

Hi there it work ok for me I did the tutorial first so I could get to grips with it

 

[Ruddles]

Okay, that's good news. Perhaps the OP will be able to get it working then.

 

[Norie]

Ruddles

Sorry to ask but is the script for the swapfield function on the page?

Can't view the source from here.

 

[Ruddles]

I can't see it. I think it's dragged in here somewhere:-

< script src="/js/new/login.js" type="text/javascript">< /script>
< script src="/js/new/CoreCookies.js" type="text/javascript">< /script>
< script language="JavaScript" src="/js/new/check_cbol_and_host.js">< /script>
< script type="text/javascript" src="/js/finger_print.js">< /script>
< script type="text/javascript" src="/js/leave_access.js">< /script>
< script type="text/javascript" src="/js/mwatchDivPosition.js">< /script>