How to get redirect url using Excel VBA or Python

Getting some tiny URL, that redirects you to somewhere else might be dangerous. There are a lot of people, that would never ever click on bit.ly/something or goo.gl/something, just because they do not know where the redirect is going to bring them. And they probably have a point.

A nice path, that does not redirect anyone, anywhere.

Anyway, here I will show you how to get the target of the redirect url with Excel VBA and with Python.

With Python we use Requests

With Excel VBA we use CreateObject(“WinHTTP.WinHTTPRequest.5.1”)

Well, that’s all!

Tagged with: , , , , , ,