Printing to pdf

[christian77]

Merry x-mas and happy new year everybody!

I need to print (create) a pdf file. It must be automatic. When I do it, it shows the 'configuration window' and the 'save as' window.

I must skip those two windows, since I need it to be absolutely automatic. I need to print a pdf per business unit, and they are more than hundred.

Everything is ready in a loop, but it´s stopping twice every time and I can´t afford that.

Does anybody know how to control or fix those properties within the macro?

'''''''''''CREA DOCUMENTOS CON EL INFORME DE CADA FRANQUICIA

'''''''''''CREATES A DOCUMENT FOR EVERY BUSSINES UNIT

sub ImprimirPDF

"Franquicia_id Origen"). Select ""

set Valores=ActiveDocument.Fields("Franquicia_id Origen")

msgbox("The field has "& Valores.GetCardinal &" values") 'SHOWS THE NUMBER

for i=0 to Valores.GetCardinal-97 I´M TRYNG WITH 3 ONLY, TO SAVE TIME

"Franquicia_id Origen"). Select right("000" & (i+1),3)

set val7=ActiveDocument.Fields("Franquicia Origen").GetPossibleValues

msgbox("" & val7.Item(j).Text)

set WSHShell = CreateObject("WScript.Shell")

"c:\temp\qlik.pdf"

"HKCU\Software\QlikViewPDF\OutputFile", pdfPath, "REG_SZ"

"HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"

"RP01", "QlikViewPDF", true 'REPORT TO PRINT

set WSHShell = nothing ' 'En Windows 7 no guarda automaticamente

next

"Franquicia_id Origen"). Select ""

end sub

By the way, first you need to install pdf exchange, available at QV site.

Thanks in advance.

[#2]

Instead of developping a macro and wasting development time Maybe you would be interested to test the Cilprint software ?

It allows you very easily to generate and update Word document based on Qlikview dashboard.

The trial version is at this page: Normal 0 21 false false false FR X-NONE X-NONE MicrosoftInternetExplorer4 http://bit.ly/i2eIhT

Licence cost is 150 EUR / user / machine

Feel free to ask us in case of questions at cilprint@cilaos-conseil.com.

Rgds,

Sébastien