You could use code like this:
Dim sInput, sOutput As String
Dim iASCIICode As Integer
Dim i As Integer
sInput = "100001100100011011000110"
For i = 1 To Len(sInput) Step 8
iASCIICode = 0
iASCIICode = CInt(Mid(sInput, i, 1)) * 128
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 1, 1)) * 64
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 2, 1)) * 32
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 3, 1)) * 16
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 4, 1)) * 8
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 5, 1)) * 4
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 6, 1)) * 2
iASCIICode = iASCIICode + CInt(Mid(sInput, i + 7, 1))
sOutput = sOutput & Chr(iASCIICode)
Next i