Re: [libreoffice-users] Printing Reports from BASE extends to Writer?
I expect something like this to print the document ThisComponent.printPages(Array()) Of course, you need to load it first so you would likely have something like oDoc = StarDesktop.loadComponentFromURL( URL_OF_THE_DOCUMENT, _ _blank, 0, Array() ) And then print the oDoc I did not try this, but it should work. Also, don't just close the document On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote: Yes, that seems correct. On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote: Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE extends to Writer?
Thanks I'll see what I can do. On 10/31/2014 9:28 AM, Andrew Douglas Pitonyak wrote: I expect something like this to print the document ThisComponent.printPages(Array()) Of course, you need to load it first so you would likely have something like oDoc = StarDesktop.loadComponentFromURL( URL_OF_THE_DOCUMENT, _ _blank, 0, Array() ) And then print the oDoc I did not try this, but it should work. Also, don't just close the document On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote: Yes, that seems correct. On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote: Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE extends to Writer?
Yes, that seems correct. On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote: Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE extends to Writer?
Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE
On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE
Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE extends to Writer?
Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Printing Reports from BASE
I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Reports from BASE
Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted