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

Reply via email to