stefanoste78
Member
Good morning.
I have a problem to solve. I have many urls I would like to test for.
I would need a macro to check every url of the column "a", checking if the internet page still exists (in this case the macro will insert "ok" in the corresponding cell in column "b" or "no" if the page does not exist.
If there is a page redirection, in this case I would like to write "redrict" in column "b" and insert the new url into the corresponding cell in column "d".
Regarding redirection, I would like to take into account only the differences that exist before the last "/" of the column "a" url:
Example line 4:
The url is different in the beginning "http: // www." Compared to the new url that starts only with "http: //", then it is a redirection.
You will see the diversity of lines 9-10-11
It's important to keep in mind that it's not a redirection, when what's changing is just the part that is after the last "/" of the column "a" url:
example:
Http://www.poliba.it/ e http://www.poliba.it/xxx
Lastly, in the redirect column I would like the link to be reported indicating the first degree domain, not even the part that is after "/" after the extension.
Thank you
I have a problem to solve. I have many urls I would like to test for.
I would need a macro to check every url of the column "a", checking if the internet page still exists (in this case the macro will insert "ok" in the corresponding cell in column "b" or "no" if the page does not exist.
If there is a page redirection, in this case I would like to write "redrict" in column "b" and insert the new url into the corresponding cell in column "d".
Regarding redirection, I would like to take into account only the differences that exist before the last "/" of the column "a" url:
Example line 4:
The url is different in the beginning "http: // www." Compared to the new url that starts only with "http: //", then it is a redirection.
You will see the diversity of lines 9-10-11
It's important to keep in mind that it's not a redirection, when what's changing is just the part that is after the last "/" of the column "a" url:
example:
Http://www.poliba.it/ e http://www.poliba.it/xxx
Lastly, in the redirect column I would like the link to be reported indicating the first degree domain, not even the part that is after "/" after the extension.
Thank you