posting a command to the server
 
  
 
  
 
 
 
 
 
 
    
        
        asked 12 years ago  
 
 Luis gravatar image  
 
 
 
 
    
        
        updated 10 years ago  
 
 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.
 
Preview: (hide)
 
 
 
 
          
 
add a comment