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,

Hello,

You might like this article about CRM for eCommerce

Good luck!

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

@kelahi It is used something like this -

driver.SetCapability "unexpectedAlertBehaviour", "ignore" driver.SetCapability "firefox_binary", "c:...\firefox.exe"

@ranjithkumar10

Thank you. Modified to create TMP folder on the desktop without knowing the path. Posting here for others, should the need arise.

Dim newTmp As String newTmp = CreateObject("WScript.Shell").SpecialFolders("Desktop") Debug.Print newTmp If Not CreateObject("Scripting.FileSystemObject").FolderExists(newTmp & "\tmp") Then CreateObject("Scripting.FileSystemObject").CreateFolder (newTmp & "\tmp") End If

It works same as any other loop. Just make request inside the FOR loop.

Excellent, thank you!

Session expiration has nothing to do with Keep-alive header. Everything else is answered in the code I sent you over email.