Joined: 07 Mar 2008
|Posted: Fri May 13, 2011 3:20 am Post subject: Macro for exporting only one sheet in Calc?
I have a few sheets in Calc workbook and i'm trying to figure out how to automatize process of exporting only one sheet (the active one) to a PDF file. I already tried recording a macro, but it failed, of course.
It's a relatively simple task, but since i don't how to code, it's sth i just can't solve...
Here are the steps:
File - Export as PDF... - select "Selection" - Export - Save as dialog.
The final point is just opening a "Save as dialog" and not to save it automatically to a predefined location.
I also found a few threads and codes to do a similar task, but they all save PDF files to a predefined location, or mess up a print range.
Any help would be appreciated.
Thanks in advance.
P.S. i use OOo 3.2.