(Excel) MIME Header Q and B Encoding and Decoding

Demonstrates how to Q and B encode/decode.

Download Excel Class Modules Chilkat Excel Class Modules

Dim sb As Chilkat.StringBuilder
Set sb = Chilkat.NewStringBuilder

success = sb.Append("This is a test")

Debug.Print sb.GetEncoded("B","utf-8")
'  output is:
'  =?utf-8?B?VGhpcyBpcyBhIHRlc3Q=?=

Debug.Print sb.GetEncoded("Q","iso-8859-1")
'  output is:
'  =?utf-8?Q?This_is_a_test?=

Dim sb2 As Chilkat.StringBuilder
Set sb2 = Chilkat.NewStringBuilder

success = sb2.Append("=?utf-8?B?VGhpcyBpcyBhIHRlc3Q=?=")
success = sb2.Decode("B","utf-8")
Debug.Print sb2.GetAsString()

'  output is:
'  This is a test

sb2.Clear 
success = sb2.Append("=?utf-8?Q?This_is_a_test?=")
success = sb2.Decode("Q","utf-8")
Debug.Print sb2.GetAsString()

'  output is:
'  This is a test

'  "B" or "Q" will decode both B and Q.
sb2.Clear 
success = sb2.Append("=?utf-8?Q?This_is_a_test?= 123 =?utf-8?B?VGhpcyBpcyBhIHRlc3Q=?=")
success = sb2.Decode("Q","utf-8")
Debug.Print sb2.GetAsString()

'  output is:
'  This is a test 123 This is a test