Extract Information From Different Websites

Im trying to extract different elements from different websites using their own individual VBA macros. I'm using XMLHTTP.

However I can't seem to make it work. I have looked into the codes as shown below and they all look so different that I dont know what to apply to extract what I want based on what I have researched so far.

Site #1 using "View page source"
Extract 5,061

Please Login or Register  to view this content.

Site #2 using "View page source"
Extract $76,8692

Please Login or Register  to view this content.

This is how a part of my codes looks like

Please Login or Register  to view this content.

Extract 5,061:
HTML.getElementsByClassName("col-md-3 px-1")(0).getElementsByTagName("p")(1).innerText

Extract $76,8692:
HTML.getElementsByClassName("Text__TextBase-sc-1cait9d-0-div Text__TextContainerBase-sc-1cait9d-1 hlvKRM")(0).innerText

Hi efvba, thank you so much. I have a followup question though.

I want to extract $74,000 from the "View page source" code below:

Please Login or Register  to view this content.

Im using

Please Login or Register  to view this content.

and it does not seem to work. Why is that? The website requires a login but I have already placed the credentials on that website even before opening any excel file.

You need to login through VBA if doing this method. Your web browser and VBA are unrelated

But there is also a hyperlink on the same workbook that will allow me to access the specific page on that website, and it takes me there with no problem at all.

Hyperlinks open in your browser, they're nothing to do with the XMLHTTP60 object

I see. Good point. Can you help me with the code?

Not without the website

Its https://www.narrpr.com

I think you didn't succeed in getting HTML you want.

After getting the reponseText, you can check if the Class exists in HTML.

How to do that? Is it through your code?

Open the Immediate Window (Ctrl + G) in VBA. "debug.print" will output responseText to there.

Please Login or Register  to view this content.

Could you post the responeText output from the VBA Immediate Window?

Your code is ok, so I need to view your HTML.

Please Login or Register  to view this content.

You just need to run the above code. "url" is that you cannot extract the data, then copy the output from the VBA Immediate Window and post it.

Your responseText is login HTML only, so you cannot get your data.

You may try to find the class "price priceGray" that is not found in Notepad. You must get the right HTML to extract the data you want.

I actually put the URL on that VBA where it would lead me to the website that contains the information that I want, which is under the class "price priceGray". I cant put the exact URL here because i think it would lead you to the login page first before you can actually go to the desired part of that website.
Do you think the reason why it returned the login HMTL instead of the intended HMTL is because it is asking for the login credentials first? Maybe its something that we need to get around first?

Your attachment is not valid.

I cannot test your URL because it needs credentials. You can try the following code to automate IE:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Hi efvba, its my fault. The www.narrpr.com is a different concern from the one on the attachment. They are two different websites of which i want to extract two different information.
i want to extract "price priceGray" from the www.narrpr.com and "$52,000" from the one on the attachment.