Re: Forms 4.5 OLE2-package

Hi Matthias.

Have you tried looking at all of the Macros that the Excel application has?  If you look at the Visual Basic editor in Excel, under Tools->Macro->Visual Basic Editor, you can look at the object navigator(F2) and see what is Macros, or Methods of the Excel object you can use.

One way which Oracle suggests working with OLE etc, is to create your own macros in a Template document, then you call the macro from Excel, and the work is done. The nice thing about this is that the macro can be easily recorded by you.

Hope this helps a bit.

Brad

Matthias Schmitt <nc-schmitma7_at_netcologne.de> wrote in article <34C25E23.1B6A87C2_at_netcologne.de>...
> I'm trying to use the OLE2-package to open an Excel-application.(Office
> 97)
> I would like to export columnvalues into Excel.
> The 'Oleexcel'-demo in Forms 4.5 didn't work.
> Is there a change to use this package with excel 8?
> Could someone give me a working example?
>
> Thanks, Matthias
>
> Please reply to
> nc-schmitma7_at_netcologne.de
>
>
  Received on Mon Jan 19 1998 - 00:00:00 CET