@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.

@ranjithkumar10

Ranjith, your Forum is great for me. I appreciate knowledgeable persons of whom are kind to instruct and share.

I am hoping you can be my JSON person of whom, I can become an expert in all aspects of JSON.

I am pursuing Certifications from W3 to begin, and expand from there with other earned credentials.

Below is my curriculum:

https://youtu.be/2mDhbMvtTk0
coding KARMA - at least I am doing something about it!

Lynda.com
Udemy.com

HTML5

CSS

JavaScript Essential Training - Joe Marini

Mobile Web Fundamentals - Joe Marini

jQuery Essential Training - Joe Marini
5a. jQuery Code School http://try.jquery.com

jQuery Mobile Essential Training - Joe Marini

JSON - Ranjith Kumar - https://forum.codingislove.com/

paramQuery PRO -- ? instructor / courses to be found

XHR - XMLHttp Request -- ? instructor / courses to be found

API - David Berlind - https://www.programmableweb.com

Node.js / React / - Mike Dalisay - https://www.codeofaninja.com/

Today, my focus is to complete the project you assisted me, regarding the second XHR with the jsession cookie.

"That website is using JsessionId for security. I don't know what's their expiry period. If it is forever then this will work - https://bin.codingislove.com/ejacugimix.vbs

If sessionId expires in a day or after few hours then you have to make one request for accepting the terms which sends jsessionId in cookie. Then you have to parse it using http.getAllResponseheaders() method and use it in further POST requests as mentioned.

Am reviewing these instructions to resolve the jsessionid cookie.

Any supportive links for instruction in this, greatly appreciated.

Thank you.

@RK-Rishikesh-Sinha Someone has already answered this question here. Check the last comment with an example google spreadsheet.