| Invoke printer dialogue in excel using OLE2 [message #87731] |
Fri, 04 February 2005 16:32  |
Raj Nandipati
Messages: 3
Registered: February 2005
|
Junior Member |
|
|
Hi,
We have a requirement is to print excel spreadsheet form the form.
Using OLE2 we are managed to open the required excel spreadsheet.
But, we would like to invoke either printer/print preview/pagesetup dialog box in excel automatically when they press button on Forms.
Any idea ... Thanks in Advance.
Cheers,
... Raj
PS: We are using Forms v 9.0.4.0.19
|
|
|
|
| Re: Invoke printer dialogue in excel using OLE2 [message #87732 is a reply to message #87731] |
Fri, 04 February 2005 16:51  |
Salim
Messages: 6
Registered: May 2003
|
Junior Member |
|
|
i would suggest write a macro on excel with a button on excel sheet that way you can use the funcstionality within excel itself
I dont know how you will do it on from forms
hope that helps
Does anyone have 9i selftest i need that thanks in advance
|
|
|
|
| Re: Invoke printer dialogue in excel using OLE2 [message #87739 is a reply to message #87732] |
Sun, 06 February 2005 15:35 |
Raj Nandipati
Messages: 3
Registered: February 2005
|
Junior Member |
|
|
Hi Salim,
Thanks for your reply.
As I mentioned we are using 10g-application server.
We don't have a control on client level excel application once we drop it middle-tier.
It's hard to implement the macro on each client PC.
Oracle providing a utility ORARRP to invoke printer dialog, but it does not suit for excel files.
That's why we are looking some OLE2 function that will invoke printer.
Cheers,
... Raj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
