Short script found somewhere on the Internet for encoding URL in VBA: Function URLEncode(EncodeStr As String) As String Dim i As Integer Dim erg As String erg = EncodeStr ‘ *** First replace ‘%’ chr erg = Replace(erg, “%”, Chr(1)) ‘ *** then…