Hi all
For several years I have used Chandoo's GetTinyURL code to get shortened URLs via VBA. This now requires authentication, and whilst I know how to GET the required API key, I don't know how to USE it!
FYI this is a summary of the old code:
Set xml = CreateObject("MSXML2.XMLHTTP.6.0")
xml.Open "POST", "https://tinyurl.com/api-create.php?url=" & LongURL, False
xml.Send
GetTinyUrl = xml.ResponseText
But now we need to add an authentication token somehow. I have found one question on Stack Overflow on this - but it has no answers!
Can anyone here help, the original code came from Chandoo so hoping here is the right place!
For several years I have used Chandoo's GetTinyURL code to get shortened URLs via VBA. This now requires authentication, and whilst I know how to GET the required API key, I don't know how to USE it!
FYI this is a summary of the old code:
Set xml = CreateObject("MSXML2.XMLHTTP.6.0")
xml.Open "POST", "https://tinyurl.com/api-create.php?url=" & LongURL, False
xml.Send
GetTinyUrl = xml.ResponseText
But now we need to add an authentication token somehow. I have found one question on Stack Overflow on this - but it has no answers!
Can anyone here help, the original code came from Chandoo so hoping here is the right place!