I don't have any account there so I could not check. However, try this. It should work.

Sub GetLoggedIn() Const Url$ = "https://my.bexio.com/simplesaml/module.php/core/loginuserpassorg.php?client_id=7753313026.apps.bexio.com" Dim Http As New XMLHTTP60, HTML As New HTMLDocument Dim auth As Object, authval$, payload$ With Http .Open "GET", Url, False .send HTML.body.innerHTML = .responseText End With Set auth = HTML.querySelector("form[name='f'] input[name='AuthState']") authval = WorksheetFunction.EncodeURL(auth.getAttribute("value")) 'put your username and password in the following line replacing xxxx 'make sure to replace "@" with "%40", as in [email protected] with something%40gmail.com payload = "username=xxxxxxxxx&password=xxxxxxxxx&AuthState=" & authval With Http .Open "POST", Url, False .setRequestHeader "Content-type", "application/x-www-form-urlencoded" .send payload End With MsgBox Http.responseText End Sub

this is how i access the api through curl

curl -F "apikey=d8a40f77-69b5-4ef7-b554-d8f86382101c" "https://ktsstf.org/call.php?apicall=registration.data&apiDataType=xml"

is this question too much of a challenge here ?

@jrenforth I don't know if you posted the wrong code above or the code itself is like that! There are 2 functions named conditionalMail() and the first function is not closed either. Please check your code again. There are too many errors.

Is the email delivering late or it isn't coming at all?

Thanks... I have since got Selenium wrapper working... on some sites, just peachy. Works a treat ;-) Yes i needed to get the latest chrome driver, after that - all good!.

I have an issue with one site I really want to get to... login to https://myibd.investors.com/secure/signin.aspx?eurl=https%3A%2F%2Fmyibd.investors.com%2Froadblock.aspx%3Fprevurl%3D%2f%26tool%3Dmy%2Bibd%2B-%2Binvestors.com. I am a paid subscriber...

Using exact same method as other site, I cannot even get started, ie picking up the username input just fails. Wondering what is special here... could it be OAUTH? I know nothing about that... but saw it mentioned elsewhere. I have no idea even how to tell if this site uses some such authentication... any suggestions?

If I should open this in another thread.. let me know ;-)

Cheers,

I already have thought of that .. but is it the same as chrome driver ..?

Is there a way to deal with just one page while using selenium and ignore other tabs .. this is because when trying to run a code there are other tabs opened (advertisements) and I want to make the desired tab active all the time

Hi @kenlihoyin This code should work :

Sub Revisedrunner() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim cellv As Integer cellv = Cells(2, 7).Value Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate "http://www.etnet.com.hk/www/eng/stocks/ci_ipo_detail.php?code=08479&type=listing" Do While IE.Busy Or _ IE.readyState <> 4 DoEvents Loop Dim rowElements As Object, rowElement As Object, columnElement As Object Set rowElements = IE.document.getElementsByClassName("figureTable")(1).getElementsByTagName("tr") i = 3 For Each rowElement In rowElements j = 1 For Each columnElement In rowElement.getElementsByTagName("td") Debug.Print columnElement.innerText Cells(i, j).Value = columnElement.innerText j = j + 1 Next i = i + 1 Next IE.Quit Set IE = Nothing Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic MsgBox ("Done!") End Sub