Re: Need Help with Oracle and Word '97

From: Jim Anderson <anderson_at_h2o.mrd.usace.army.mil>
Date: 1997/04/17
Message-ID: <335688A5.6974_at_h2o.mrd.usace.army.mil>#1/1


Secretaria de Integracion Economica Centroamericana wrote:
>
> Greatings!
>
> We are developing an oracle aplication that needs to keep some information
> in HTML format, then we need to make an interfase with Word '97 to look and
> edit this HTML code in WORD MODE then we need to put it back in the
> database in HTML format.
>
> Our Question is:
> Is there some Vbx Control or another way to do this interchange, without to
> saving the HTML source into a file?
>
> We have ORACLE 7.3 for windows NT, SQL*Plus 3.2 for Windows '95, developer
> 2000 for windows '95, Designer 2000 for Windows 95, Forms 4.5 and MS OFFICE
> '97 Pro.

Hello,

You can use Oracle Objects for OLE to do this. I am using OO4O to extract data from an Oracle DB and bring it into Excel using VBA. With Office 97, VBA is available in all office products. You may run into one problem, though. My application works fine with Excel 95, but I get automation errors with Excel 97. I'm not sure if Oracle has certified OO4O to work with 97 products. If you find out, let me know.

Jim Anderson Received on Thu Apr 17 1997 - 00:00:00 CEST

Original text of this message