Open new threads only

[YasserKhalil]

Hello everyone

Is there a way to open the new threads with the new replies only in the forum ... ?

I mean to navigate to the forum and open the new threads that is not read or the threads that has new replies in one shot

Thanks advanced for help

[AliGW]

This is the link to new posts:

https://www.excelforum.com/search.php?searchid=8623056

I don't understand what the problem might be ...

[YasserKhalil]

Thanks a lot for reply
In the link provided
'Sorry - no matches. Please try some different terms.'

The problem is that I want to open all new threads in one shot : each thread in new tab in the broswer..
I don't mind if there is a code to do that ..

[AliGW]

OK, well then it would have been sensible to say this in the first place.

Please explain in DETAIL what it is you are trying to do.

[YasserKhalil]

OK. I thought it is clear
Generally glad it is clear now
Thanks a lot for sharing

[AliGW]

Well, no - it's not clear to me exactly what you want to archive or why, but hey!

[YasserKhalil]

Here's my attempt by code

Please Login or Register  to view this content.

I have commented the desired part .. I want to list in column A , the new threads for me (that have new replies I didn't see)
Hope it is clear now

[YasserKhalil]

Any help in this topic please?

[YasserKhalil]

Hope to find responses to this topic ..

[Kyle123]

You want:

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. Kyle for reply
I already tested that part

Please Login or Register  to view this content.

But I got type mismatch error (run-time error '13')

[Kyle123]

That means there aren't any. As far as I can see from your code, you never navigate to the page in your screenshot. The link for that page is:

Please Login or Register  to view this content.

[YasserKhalil]

I waited till there are new threads for me and retest the code but the same error .. I even replaced my link with the link you provided without opening it and I got the same error. I am using IE 11 and windows 7 32 Bit

[Kyle123]

Please post your actual code

[YasserKhalil]

My code posted at post #7. That's my actual code

[Kyle123]

That code doesn't have any of mine in it

[YasserKhalil]

Do you mean the code after the modifications you guided me

Please Login or Register  to view this content.

[Kyle123]

On which line do you get the error? Bear in mind that there will not be an li within the elements found

[YasserKhalil]

I got error at this line

Please Login or Register  to view this content.

[Kyle123]

1. You aren't waiting for the redirect before logging in
2. oHEle shouldn't be declared as HTMLUListElement

You may want to adjust the below as you could end up in an infinite loop should the password be incorrect

Please Login or Register  to view this content.

[YasserKhalil]

Awesome. Thank you very much
That's working great and as expected ..

One last point if possible : How can open each link in new tab in IE?

[Kyle123]

Ie.navigate2 x.href, 2048&
Though I suggest you don't. It opens them too quickly and you'll get your ip blacklisted

[YasserKhalil]

Thanks a lot for suggestion
What 2048& refers to ???! If we make a waiting time between opening the links I think this would solve the IP issue

[Kyle123]

It’s an enum value for telling ie to open in a new tab

https://msdn.microsoft.com/en-us/lib...(v=vs.85).aspx

[YasserKhalil]

Thank you very very much
I have tested the code and it is great ..
I used these two lines

Please Login or Register  to view this content.

Just one note : when opening the links ..if a thread has more than a page (two pages for example), it opens on the first page
What is the trick I can use to open the last page?

[YasserKhalil]

Just one note : when opening the links ..if a thread has more than a page (two pages for example), it opens on the first page
What is the trick I can use to open the last page?

[Kyle123]

There's no trick, just inspect the source code for the link that takes you to the last post and navigate to that instead of the link extracted above

[YasserKhalil]

I couldn't get how to do that. I inspected the source code but didn't know hot to get the code to navigate to the last page

[Kyle123]

Look at the href of the button that takes you to the last post

[YasserKhalil]

Thanks a lot for your patience
I am trying to inspect and try to know how can I solve it but I really don't know
When inspecting a thread of two pages I got two links like that
Untitled.png
But I don't know how to code to deal with the last page or last link

[Kyle123]

You're looking in the wrong place, to go to the last post, you click the link in the last post column next to the username - this has the link you need

[YasserKhalil]

Do you mean like that .. if not please leave a snapshot as I am lost
Untitled.png

[Kyle123]

No, I don't. See attached

[YasserKhalil]

I think I found the part you are talking about

But how can I reach this part ..Can you help me please?
Untitled.png

[Kyle123]

What have you tried so far?

[YasserKhalil]

I am trying to find a clue for how to reach this point but I am lost. I used Google Chrome and copied the XPath
//*[@id="thread_1247090"]/div/dl/dd[2]/a[2]
But I have no idea of how to use XPath ..

[Kyle123]

I think you need to read up on HTML and the DOM, this will give you a much better idea of how to navigate a page:

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much. That works like charm but I really would like to get how did you do that line of code
As for the method offsetParent .. How does it work? And how I can detect the parent of the element?
Untitled.png

[Kyle123]

There's a lot to learn - it would take an essay to explain it, I can't really explain it to you here. You need to read up on HTML and the DOM

[YasserKhalil]

Thank you very much for great help. I will try to read again about DOM
Best and Kind Regards