Print selected pages without printer name

[abhiabhi_84]

Hi,

Is it possible to print a few sheets without providing printer name.

Example:

I have a file having 15 sheets. I want to print sheet number 2,3,6 and 8. Also i have users at different location. Hence i cannot give printer name in macro. Can a default printer be picked or printer dialog can appear so that user can select his connected printer.

Kindly provide suggestions.

Regards,
Abhi

[acknak]

[Moved to Macros and UNO API]

[abhiabhi_84]

no replies?

[abhiabhi_84]

Hi Guys,

I could not found answer to my question so i used default printer.
Now i have a different doubt.

I am using Doc.Print(PrintArray1()) to print document.
But this function prints pages from Active Sheet only.

So i used following code to set active sheet.
Doc.getCurrentController().setActiveSheet(Sheet1)

though this sets active sheet but do not print pages from that page.
page gets active only if i give any message box.

Why i need to show a message box?
Kindly provide your suggestions.

Regards,
Abhi