@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.
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 ;-)
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
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
Do While IE.Busy Or _
IE.readyState <> 4
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")
Cells(i, j).Value = columnElement.innerText
j = j + 1
i = i + 1
Set IE = Nothing
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
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")
If Not CreateObject("Scripting.FileSystemObject").FolderExists(newTmp & "\tmp") Then
CreateObject("Scripting.FileSystemObject").CreateFolder (newTmp & "\tmp")
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.
Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.