VBA login into website

[malortje]

Hi Guys,


Tried a lot but I can't figure out how to login on this website.
Could someone please help me out ?


I want to scrape some data from a website but I couldn't even login with VBA code because it's keep saying "Object doens't support this property or Method" with this code:

Sub GetPrintStats()
Set IE = CreateObject("InternetExplorer.application")
Set IE = GetObject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E}")
 
With IE
.Visible = True
.navigate ("http://10.209.58.26/?MAIN=LOGIN")
End With
While IE.Busy: DoEvents: Wend


Set doc = IE.document


doc.getElementsByTagName("input")(0).Value = "xx"
 
End Sub

Or with these code I got : "Object variable or With block variable not set"

Sub GetPrintStats()
Set IE = CreateObject("InternetExplorer.application")
Set IE = GetObject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E}")
 
With IE
.Visible = True
.navigate ("http://10.209.58.26/?MAIN=LOGIN")
End With
While IE.Busy: DoEvents: Wend


Set doc = IE.document


doc.getElementById("USERNAME").Value = "xx"


End Sub

 

[malortje]

 

[malortje]

sorry above is the HTML code that is from the website where I want to login. But I can't insert pictures here

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1277464-login-into-website-vba.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[malortje]

Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1277464-login-into-website-vba.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Sorry for not posting a link to the cross post!