WorksheetFunction.EncodeURL (Excel)

URL encodes the argument.

This method enables the referencing of other cells as arguments into the Web Service URL, as this will ensure that the data will be URL encoded.

EncodeURL (Arg1)

Arg1: Text to be encoded.

Dim strArg1 As String: strArg1 = 
Dim strEncodeURL As String
strEncodeURL = WorksheetFunction.EncodeURL(Arg1:=strArg1)