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
