calling ocaml from VBA

calling ocaml from VBA

[Lars Schouw]

How I call ocaml code from VBA?
Can I warp the compiled ocaml code into a dll somehow?
Then I can use 'declare funcion' in VBA.
Lars 


		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 

Re: [Caml-list] calling ocaml from VBA

[James E. Scott]

Hi Lars!

we do something like the following:

- write a DLL which is a 'client' and which has a function 
(eval_expression) callable from VBA (written in C and caml).

- write a server, which is an ocaml toplevel but which marshals it's IO. 
Then the client runs the server and talks to it through stdin/stdout.

The client/server part is optional I suppose but it is nice not to share 
the same address space as Excel.

All ocaml return data types get mapped into a VB variant type.

James

Lars Schouw wrote:

>How I call ocaml code from VBA?
>Can I warp the compiled ocaml code into a dll somehow?
>Then I can use 'declare funcion' in VBA.
>Lars 
>
>
>		
>____________________________________________________
>Start your day with Yahoo! - make it your home page 
>http://www.yahoo.com/r/hs 
> 
>
>_______________________________________________
>Caml-list mailing list. Subscription management:
>http://yquem.inria.fr/cgi-bin/mailman/listinfo/caml-list
>Archives: http://caml.inria.fr
>Beginner's list: http://groups.yahoo.com/group/ocaml_beginners
>Bug reports: http://caml.inria.fr/bin/caml-bugs
>
>
>  
>

Re: [Caml-list] calling ocaml from VBA

[Richard Jones]

On Tue, Jul 26, 2005 at 09:51:13PM -0700, Lars Schouw wrote:
> How I call ocaml code from VBA?
> Can I warp the compiled ocaml code into a dll somehow?
> Then I can use 'declare funcion' in VBA.

I've no idea at all about VBA, but I know that it is possible to
generate a Windows DLL from an OCaml library using ODLL:

http://tech.motion-twin.com/odll.html

BTW, there is a beginners newsgroup for these sorts of questions:

http://groups.yahoo.com/group/ocaml_beginners/

Rich.

-- 
Richard Jones, CTO Merjis Ltd.
Merjis - web marketing and technology - http://merjis.com
Team Notepad - intranets and extranets for business - http://team-notepad.com

Re: [Caml-list] calling ocaml from VBA

[clement.capel]

yes, you can. but it's a little bit long and technical ...
- write you ocaml files.
- use the ocaml/C binding to generate C object files.
- create a C++ dll to call your C functions.
- In this dll you have to map C values to VBA values (COM objects).

- then (and finally), for instance:

Declare Your_function Lib "your_dll.dll" _
(ByRef argv() As String) As String


(the dll must be in the PATH)


regards

Clément



Quoting Lars Schouw <schouwla@yahoo.com>:

> How I call ocaml code from VBA?
> Can I warp the compiled ocaml code into a dll somehow?
> Then I can use 'declare funcion' in VBA.
> Lars
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
> _______________________________________________
> Caml-list mailing list. Subscription management:
> http://yquem.inria.fr/cgi-bin/mailman/listinfo/caml-list
> Archives: http://caml.inria.fr
> Beginner's list: http://groups.yahoo.com/group/ocaml_beginners
> Bug reports: http://caml.inria.fr/bin/caml-bugs
>