How to load data on a data block to Microsoft excel in oracle 6i forms

[tracyyy]

I’m developing an application using oracle 6i forms.
I have created an oracle form which has a data block and a button called “Load to Excel”.
I want to load the data in the data block to Microsoft excel when the button is pressed using the WHEN-BUTTON-PRESSED built-in.

Does anybody know how that could be done?

And how to open Microsoft excel using a button in an oracle form?

Pls help its very urgent
Thanks
Tracy

 

[taupirho]

Tracyy, there are a number of ways of doing this. One of which is using Oracle Objects For Ole - not as bad as it sounds , another way is to use DDE. To get more info go on over to my Oracle Tips website at

http://the-big-o.port5.com

and you'll see a couple of articles which explain both methods. Hope this help.

 

[tracyyy]

hey tom,
Thanks for the help.
i put the code that you had given in the DDE excel example to a WHEN-BUTTON-PRESSED trigger, but it didnt work. there was a compilation error. it said

bad bind variable 'var'
bad bind variable 'id'

what have i done wrong? what should i do to get this option working? please please help me Tom
i need to load datablock into excel at runtime.

thanks in advance
Tracy

 

[taupirho]

Tracyyy, the variables :id and :var are what the fields on my form were called. Substitute these with the appropriate variables/fields on your own form. Remember the code shown in the article is only an example of how you do things, it shouldn't be copied verbatim. You will have to change a few things to suit your own circumstances such as variable names