How to make Excel automatically login on a website so it can retrieve data from the site

I used some data from a website in my workbook, and it works fine, but every time I re-open the excel file, I have to go to "edit query" and manually log in to the website. How can I make it so either it automatically logs in with a pre set mail and password, or so that there is a login form in my excel sheet so I can log in manually from there.

Well I know some basic HTML and how to how to find certain elements on the website, but I'm new to Macros in excel and VBA. I tryed to use some VBA code that I found online, and changed the code to my needs, but it always gave me some kind of error that I didn't know how to fix.

Post your code.

Sub test()
' open IE, navigate to the desired page and loop until fully loaded
Set ie = CreateObject("InternetExplorer.Application")
my_url = "https://ocjene.skole.hr/pocetna/prijava"

With ie
.Visible = True
.Navigate my_url
.Top = 50
.Left = 530
.Height = 400
.Width = 400

Do Until Not ie.Busy And ie.readyState = 4
DoEvents
Loop

End With

' Input the userid and password
ie.Document.getElementById(user_login).Value = "username"
ie.Document.getElementById(user_password).Value = "password"

' Click the "Search" button
ie.Document.getElementById(submit).Click

Do Until Not ie.Busy And ie.readyState = 4
DoEvents
Loop
End Sub

Well the sumbit button does not have an ID, so I don't know what to do. And besides that, the username and password doesen't enter in the fields either.

Try this one for login and pass

Please Login or Register  to view this content.

I do not know what this word means "Prijava"

Please Login or Register  to view this content.