posting a command to the server

asked 2012-12-08 03:11:03 +0100

Luis gravatar image

updated 2015-01-13 21:50:15 +0100

FrédéricC gravatar image

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.

edit retag flag offensive close merge delete