i have a working bot and getting the public API was easy.
let me post a few snippets for you:
html = ""
myURL = "http://mtgox.com/code/data/ticker.php"
winHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")
winHttpReq.setTimeouts(60000, 60000, 60000, 60000)
winHttpReq.Open("GET", myURL, False)
winHttpReq.SetRequestHeader("Content-Type", "application/x-www-form-urlencoded")
On Error Resume Next
winHttpReq.Send()
html = winHttpReq.responseText
From there, you can parse the html and get what you need from it.
and for getting your own personal stuff:
Sub getBalance()
'Get Balance???
Dim postString As String
Dim postArray() As Byte
html = ""
postString = "name=" & username & "&pass=" & password
postArray = System.Text.Encoding.GetEncoding(1252).GetBytes(postString)
myURL = "https://mtgox.com/code/getFunds.php"
winHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")
winHttpReq.setTimeouts(60000, 60000, 60000, 60000)
winHttpReq.Open("POST", myURL, False)
winHttpReq.SetRequestHeader("Content-Type", "application/x-www-form-urlencoded")
On Error Resume Next
winHttpReq.Send(postArray)
html = winHttpReq.responseText
End Sub
same thing, just parse the html and you can see if it works or not.