Re: Lisp COM server accessed from an Excel client

There is an example in the on-line material for Allegro, in
OLE/samples/sample08 which should answer your questions.
It should not be necessary to contact ronen, who is a grad
student in Israel, at the moment.
RJF


Maurice Fingher wrote:

> 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
>