URL Code Checker = Finding if an URL is a 200, 307 or 404

Hello There,

I am trying to figure out the formula or macro that would provide me the status of a URL. I was able to find out on a Google Sheet, however, ideally, I could do it in Excel.

As per the title, essentially, entering an URL in a cell, the one located besides it in the next column would have a formula that displays the online status (200, 307 and/or 404).

It seems quite complex. If you know how to do it or where I could find information related to it that could help, I would sincerely appreciate your support.

Thank you, All!

Laurent

Hopefully this will get you started. URLS go in Col A.

Please Login or Register  to view this content.

Logit! Thank you so much for taking the time to write down the macro! Much appreciated

It works well! Ideally, I would like to only display one URL status (my objective once running the script is to filter and extract only the 307). When running the script, it shows "200 or 307" in the cell. I located the script that needs to be edited (below) but can't figure out how to do it to make it works (My macro knowledges are pretty limited).

If getStatus <> "307" And getStatus <> "200" Then
.Cells(i, 1).Interior.ColorIndex = 3
.Cells(i, 2).Value = "404"
Else
.Cells(i, 1).Interior.ColorIndex = 4
.Cells(i, 2).Value = "200 or 307"

If you could help with it that will be awesome

Thank you again for all your help, Logit!

Laurent