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