Do you see a similarity between these lines:
intPos = InStr(strBuffer, vbCrLf)
posA1 = InStr(strInput, "A1:")
In one case you store the return value in what looks like an int. In the other, you store the return value in a string. Why?
bufferA1 = Mid$(strInput, 1, posA1 + 6)
Now, you are adding 6 to a string. What do you expect the result of that operation to be?
temp4 = Left$(bufferA1, 1, ((ingLen - bufferlocA1) + 3))
Now, here you are subtracting a string from something (an int?) and adding 3 to the result. What is ingLen? Why is it named the way it is? What do you expect to have happen when you subtract a string from it? What type is the result of (ingLen - bufferLocA1)?