VBA write info to google spreadsheet

[auto]

hi, everyone
hope i can get here an answer
i am surfing around the web all over to check for a solution, but i cant get anywhere, maybe someone here can help me
i have an excel sheet which has a macro doing some stuff with the data in it, and i want when the sub is finishing the work to get out two values from two different ranges and paste it into my google spreadsheet.
now i started with some code but i am missing something, i will share here my code, maybe someone can tell why its not working.

[COLOR=#222222][FONT=Verdana]Sub test()[/FONT][/COLOR][/FONT][/COLOR]
' this is to test if it can write into my spreadsheet'
Dim a As String
a = "testing"
Dim Mysite As Object

Set Mysite = CreateObject("WinHttp.WinHttpRequest.5.1")
Mysite.Open "POST", "https://docs.google.com/spreadsheet/pub?key=0AvtzA1pEG-VWdDJnZ0prckJMZmotMWM1TUFtOGdPRFE&output=html", False
Mysite.send a

'Check result
MsgBox Mysite.Status
MsgBox Mysite.statusText


[COLOR=#2A2A2A][FONT=Segoe UI][COLOR=#222222][FONT=Verdana]End Sub[/FONT][/COLOR][/FONT][/COLOR]

can anyone help me please?