M3-Lite and VBA

Hi, All!
How can I get connect to M3-Lite server on VBA or MSExcel?

--
Posted via http://dbforums.com

SergeyKan <member34014@dbforums.com> wrote in
news:3142840.1058967362@dbforums.com:

>
> Hi, All!
> How can I get connect to M3-Lite server on VBA or MSExcel?
>
> --
> Posted via http://dbforums.com
>

with VBA or MSExcell as client, you can use the ipclient ocx wich comes
along with VB prof. The OCX can be linked to some VBA 'programs' and
establishes the connection with the M3 server either via network or as
localhost. M3 should provide the necessary broker using the IPConnect entry
in the the config.ini file of M3.
If you want to control MSExcell from M3, things are a bit more complicated
(You will need some kind of "IP serverlike-DDE encapsulation" around your
Excell.......).

Hope this helps

Armin van Harten
IfmD-consulting GmbH
Garbenheimerstrasse 6
Wetzlar, Germany
vanharten@ifmd-consulting.de