Printing a range of selected cells with macro

Creating a macro - Writing a Script - Using the API

Printing a range of selected cells with macro

Postby mijo » Fri Jun 28, 2019 3:00 am

hi
i want to print a range of selected cells using marco. i used record macro but when the recorded macro runs, it displays print dialog and i have to click "ok" button to continue printing. what i need is printing a range of selected cells only, directly without print dialog appears. can anyone help me with a simple macro example or a link which i can learn.
i am very very new in programming.
thanks for all helps

regards
open office 4 on win7
mijo
 
Posts: 1
Joined: Fri Jun 28, 2019 2:39 am

Re: printing a range of selected cells with macro

Postby robleyd » Fri Jun 28, 2019 3:08 am

A search of the forum returns a number of topics that may be helpful to you.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3458
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: printing a range of selected cells with macro

Postby Zizi64 » Fri Jun 28, 2019 6:18 am

i used record macro


You must wrirte your macros, but not record them. The recorder has a limited capability: In most of cases you need use the API functions (and sometimes the Dispatcher too) in your macros.
API: Application Programming Interface
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests