Excel data to Google Spreadsheets

Has anyone tried this? I've been trolling the internet for a couple of days, and the only thing I've seen is the following which gives me a strange compile error (attached). The compile error happens on the .Send line.

Sub test()
Dim httpRequest As MSXML2.XMLHTTP
Set httpRequest = New MSXML2.XMLHTTP

With httpRequest
.Open "POST", "https://docs.google.com/spreadsheet/pub?key="key value removed for security"&output=html", False
.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
.Send "entry.0.single=" & Sheet1.Cells(2, 1) & "&entry.1.single=" & Sheet1.Cells(2, 2) & "&pageNumber=0&backupCache&submit=Submit"
MsgBox .statusText
End With
'Check result in the following vars
'httpRequest.Status
'httpRequest.statusText
End Sub

Compile Error.PNG