Lisp COM server accessed from an Excel client

Maurice Fingher <[email protected]> Sun, 11 Jul 2004 02:10:01 -0700
Newsgroups gmane.lisp.allegro
Message-ID <[email protected]>
I'm a new user of ACL.
 
The first application I'd write would be an "intelligent" application
interacting with several Excel workbooks and a Word document.
 
The user interface would be Excel.
 
The application would work in 2 modes: simulation and solver.
 
Simulation
 
Typically a user would enter new values in a spreadsheet. A VBA function
would call a Lisp server to perform various checks and put back comments
into selected cells of the workbook. In parallel, those comments would be
inserted in a new page of a Word document. A click on a button may then
launch the simulation, i.e., do calculations (programmed in Lisp) and update
the spreadsheet. Additional comments would be inserted in some cells and in
the Word document.
 
In other words a Lisp OLE server would also access the spreadsheet (this
time an OLE server itself).
 
Solver
 
Typically a user would set objectives and constraints in the spreadsheet
and, as one expects, the solver would first offer comments on the objectives
and constraints and start trying values (which would be propagated too, of
course).
 
 
Has anybody written such an OLE application?
 
I read a paper by Prof. Fateman of Berkeley and Ronen Gradwohl, one of his
student.
 
Does anybody know the whereabouts of Ronen?
 
Thanks for your help,
 
Maurice Fingher
Tel:++972 2 930 99 96
Fax:++972 2 930 99 97