topic Print Sheet default PDF A3 size paper in QlikView

Print Sheet default PDF A3 size paper

Sun, 04 Mar 2012 19:02:51 GMT

Hi All,

I want to macro to print a sheet such a way that default printer pdf should be selected,default a3 size should be printed and should close the pdf by default.

Please suggest some solution.

Print Sheet default PDF A3 size paper

Fri, 16 Mar 2012 07:20:07 GMT

I have the exact sanme problem. Please help.

Devang.

Re: Print Sheet default PDF A3 size paper

Mon, 14 Jan 2013 14:16:35 GMT

Anyone who has managed to set default size to a4 yet?

Re: Print Sheet default PDF A3 size paper

chematos — Thu, 20 Feb 2014 17:07:42 GMT

Set xlobj = CreateObject("Excel.Application")

Set wrkbook = xlobj.Workbooks.Open(varExcelFile)

Set wrksht = xlobj.worksheets("Sheet1")

wrksht.PageSetup.PaperSize = 8 ' xlPaperA3 = 8

wrksht.PageSetup.PaperSize = 9 ' xlPaperA4 = 9

Re: Print Sheet default PDF A3 size paper

chematos — Thu, 20 Feb 2014 19:00:21 GMT

The printer is the user default printer or the local default printer, I don't know if there is a way to choose the printer without a prompt message, but if the macro would always be executed in frontend, there is no problem to setup a prompt message, if it should be executed in background.... I don't know.

Try this to select the printer:

xlObj.Dialogs(xlDialogPrinterSetup).Show

Use this to close the document:

xlobj.Close()

xlobj.Quit()