Macro for exporting only one sheet in Calc?

[BMN]

Hi.

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.