LinkBack URL
About LinkBacks
Hi Guys,
i need to get product description from this url:
xxx
Attachment 687253
I need to get whole paragraph after description atribute:
Attachment 687254
Please help how to do this
Jack
Hi Guys,
i need to get product description from this url:
xxx
Attachment 687253
I need to get whole paragraph after description atribute:
Attachment 687254
Please help how to do this
Jack
Last edited by jaryszek; 07-24-2020 at 06:29 AM.
Try this;
Please Login or Register to view this content.
Last edited by Haluk; 07-18-2020 at 07:43 AM.
Hi Haluk,
o wow thank you!
It is possible to use something like here to not open all the time IE (if i will have array loop across urls).::
source:
https://stackoverflow.com/questions/...sing-excel-vba
Please Login or Register to view this content.
I tried to use the XMLHTTP library before posting my message but the code returned an error code 403 which means "Forbidden".
So, I had to use the IE object.
thank you Haluk,
so they have some kind of restrictions there?
How to do a loop for more urls in order to not open IE constantly ?
And second questions, how can yo get class using XMLHTTP library?
Jacek
As I've mentioned, you cannot use XMLHTTP library for this URL.
Please Login or Register to view this content.
Or, using WINHTTP class;
If it was not restricted; you could get the "response text" and write to a HTML file in memory and then get the desired data from that response.Please Login or Register to view this content.
Last edited by Haluk; 07-18-2020 at 08:21 AM.
thank you very much,
so in this case it is just getting responseText so this is not by class but it is taking all and you have to loop and find specific class or json or wahtever yes ?
ok,
how to loop through a lot of urls and not constantly close and open IE?
Best,
Jacek
Your question is very general, so I can only say that; this depends on what you want to fetch from the URLs and the HTML design of the URLs.
Good luck,
Last edited by Haluk; 07-18-2020 at 03:53 PM.
let say iwant to het specific html class. How can i do this using XMLHTTP class?
and second questions --> using IE how can i loop thrugh a lot of urls in order to open only one time IE. not many times to not have bad performance.
Jacek
See this for web scraping using XMLHTTP object;
https://www.excelforum.com/excel-pro...ml#post5364077
Thank you very much!!!!
Ok,
i trued code and works wonderful!
Ok asume i have 2 urls to scratch:
https://www.g2a.com/pl-pl/minecraft-...10000032198001
https://www.g2a.com/human-fall-flat-...10000022075006
how can i do this in the loop?
(i do not want to close all the time Ie and wondering if i can just add loop and this will be working without any issues?
Jacek
Assuming that the URLs are in cells starting from A2 to down ..... the fetched data will be placed in cells from B2 to down;
Please Login or Register to view this content.
You are the boss !!
Thanks!
one more question, it is possible to take not clear text but text formatted in HTML including signs like <p> <br> and so on?
JAcek
Change this:
Please Login or Register to view this content.
to:
Please Login or Register to view this content.
thank you so much!!!!!
Jacek
You're welcome...
Sorry i can not get more repo points for you
Jacek
No problem Jacek, you're welcome ...
Haluk,
one more thing,
i have about 100 hundreds links and first IE class macro is goigng very slowly.
It is possible to fasten it somehow or rather not becasue of opening internet explorer?
this method seems to be faster but it is showing only empty msgbox in the end:
Best Wishes,Please Login or Register to view this content.
Jacek
Last edited by jaryszek; 07-20-2020 at 03:07 AM.
Jacek, if the server housing the URL does not support fetching data via XMLHHTP, I am afraid that you've to continue using the IE object.
But, the data may be fetched using Selenium drivers and in this case you don't have to use IE and Chrome can be used instead.
You will have to search for using Selenium in VBA since I've not used before.
You can download and install selenium basic from GITHUB and then you can write Selenium Code in Excel VBA
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi Guys,
thanks!
did you test selenium? Why selenium is faster than VBA IE class ?
Jacek
Last edited by jaryszek; 07-20-2020 at 04:08 AM.
Hi Always use Excel VBA Selenium for any Web automation and scrapping
Hi Naveed Raza,
thanks!
i created topics because i have issues:
Are you usingg VBA selenium add - please connect to the topic above.Please Login or Register to view this content.
Best,
Jacek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks