

September 26, 2018

Hi,
Could you please help me to create URL as I have many URLs and I want to generate all pages from each URL as below.
I have fixed URL and I know there are multi pages have the same URL but with different Number and I have pages count.
Master URL | Pages Count |
http://worldofmanufacturers.co.....ners/page/ | 3 |
So I want to create all URLs as below.
http://worldofmanufacturers.co.....ers/page/3
http://worldofmanufacturers.co.....ers/page/2
http://worldofmanufacturers.co.....ers/page/1
Please check attached to get more samples. "Column "C" is the expected macro result.
Thanks;
Ehab


September 26, 2018

Hi Philip,
I have target in my work to get a lot of companies with their websites, I need millions.
So I'm searching to get this and I found http://worldofmanufacturers.co...../category/ and I want to extract all companies and websites as below.
Company Name: B.&D. Industries Ltd.
Website: http://www.db-industriesltd.com
Above data found in this URL http://worldofmanufacturers.co.....jwhmKLE8Qd
So I want to create pages URLs as I have simple tool can be extract this, but it is very slow and have limitation .
Could you please help me about this.
Thanks;
Ehab


October 5, 2010

Hi Ehab,
We try to help people to learn how to solve problems, so with that in mind, what have you tried as a solution to this?
Have you read these articles and tried to modify the code to do what you want?
https://www.myonlinetraininghu.....g-with-vba
https://www.myonlinetraininghu.....iple-pages
https://www.myonlinetraininghu.....ling-forms
You may want to look at this tool as it might do what you want, or at least get you part way
https://www.screamingfrog.co.u.....-scraping/
Regards
Phil
1 Guest(s)
