Re: Newbie Questio- ish

It's possible you could do this in Dynamic 4GL. I saw some examples of controling Excel via DDE. Whether that's only write or read back as well I have no idea. Another way is to get an advanced terminal emulator with a resonable scripting language. Then you could send a command to the emulator (via a simple display statement in 4GL) to execute a script that controlled Excel. It could send data to Excel, read data back and give them as input to the 4GL program (as if the user typed in the data). With the Glink emulator we use this would not be all that hard to implement. Check out http://www.gar.no or http://www.gr.co.uk for more information. On Wed, 29 Jul 1998 19:15:53 +0100, Charles Millward <chaz@blakspot.demon.co.uk> wrote: >Fellow 'Mixers > >Probably not an Informix question, but ... > >Using OnLine DS 7.2 on HP-UX 10.20 and 4gl that comes with 7.2. >Currently we call "C" functions to work out actuarial calculations >returning a 400 element array with the data we require for posting to >various tables. > >We now want to access a Microsoft Excel spreadsheet on a PC with the >actuarial formulas, bring back to 4gl on the Unix box and make the >calculation with a mix of C and 4gl > >Anyone any idea how we connect to the PC, open the spreadsheet, return >the correct calc and bring it back to unix. > >All positive suggestions greatly accepted > >Chaz > Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)