VBA to Linux Interprocess Communication System
What is BrainSquash?
BrainSquash is a system that allows any VBA application ( Excel, PowerPoint, Word, OutLook, VB.NET, etc.) to communicate with Linux and Linux applications. The VBA code references
a COM object that sets up a connection to the
, a customize TCP server on Linux with shared modules that load dynamically when called from the VBA application.
The shared modules can be customized and expanded. Currently in development are modules for MySQL. (Reference
The following subroutine will establish a connection to the Linux server. Before this will run the COM object ComSocketConnect must be built. You can get from the CVS download, until the project moves out of alpha. You'll need VB.NET to combile and load ComSocketConnect.
Sample Excel VBA
' Make sure you change this ... you need to use your IP!
(r.initialSetup("126.96.36.199", 10001) = 0)
MsgBox("Can not connect to server ")
r.connectStatus <> 0
r.sendDataStream("<FLIP><NUM>1</NUM><TIME>" & Now & "</TIME><CURPOS>12</CURPOS><NAME>Excel</NAME>")
& "<SCRAPETIME>" & Now & "</SCRAPETIME>" _
& " <PPTNAME>EXCEL</PPTNAME><SLIDENUM>12</SLIDENUM><SLIDEPOS>5</SLIDEPOS>" _
& "<SLIDETEXT>more text</SLIDETEXT></SCRAPE>")
Excel VBA applictions can write to MySQL on Linux
Capture Flips in PowerPoint
Two way communication from multiple apps