posting a command to the server
I'm trying to send data to the sage notebook server from MS Excel using a VBA macro. I want to run something like this (In the excel macro):
Sub lookForIt()
Dim objHTTP As Object
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP") URL = "https://The Address of my Linux machine running Sage:8080" objHTTP.Open "POST", URL, False objHTTP.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" objHTTP.send ("Hi HERE is my commands, obvioulsy this is a very general idea") End Sub
Until now I save my Excel data into a text file and then switch to a browser with a sage notebook and just run the commandas manually. I want to automate this step.