Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-07-11 12:29 AM

Script for Exporting and Sending email

Hi Everybody,

Please help me the script to export the Qlikview documents into Excell/PDF file and the script to send email in Qlikview environment.

Many thanks,

Tai.

59,810 Views
85 Replies
Not applicable
‎2012-06-21 03:46 AM
Author

In response to

I am using 64 bit  system......thats y its not working    ....

530 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 09:39 AM
Author

In response to

im going to upgrade my qlikview to v11 this week, and ill test the dashboards of my company..ill tell you any issue or new.

530 Views
0 Likes
Not applicable
‎2012-08-22 11:02 AM
Author

JochenAndries,

I've done everything and is giving the following error:

The ActiveX component can not create object: 'Bullzip.PDFPrinterSettings'

Do you have any tips to resolve this?

529 Views
0 Likes
Not applicable
‎2012-08-27 02:00 PM
Author

friends,

after implementing this macro as I do to open the document to do some maintenance?

529 Views
0 Likes
Not applicable
‎2012-08-27 03:04 PM
Author

In response to

Discover, just hold the SHIFT and open the document.

thank you

529 Views
0 Likes
Anonymous
Not applicable
‎2012-08-31 05:44 PM
Author

In response to

just disconnect your rj-45 from the machine, then a window will appear !

529 Views
0 Likes
Not applicable
‎2012-09-19 03:05 AM
Author

Hi Jochen,

it is indeed amazing solution, however i am facing one issue while exporting through QlikviewPDF or Bullzip PDF. the issue is i am always getting SAVE AS window.

how can i avoid and set default path. My script look like this. and personally i am using Window 7 x64 bit machine.

Sub ExportAndMail

    'ActiveDocument.reload

    vReport = "RP02" 'Set report

    vName = "QlikView Printing" 'Name of output pdf

    ActiveDocument.PrintReport(vReport), "Bullzip PDF Printer", false  'Printreport

    reportFile = "C:\Users\Gaurav\Desktop\" & vName &".pdf" 'Setting outputname

    MyPrintPDFWithBullZip(reportFile) 'Call pdf printer

    ActiveDocument.GetApplication.Sleep 5000

    mailrapport()

    ActiveDocument.Save

    ActiveDocument.GetApplication.Sleep 5000

   ' ActiveDocument.GetApplication.Quit

End sub

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)

    set obj = CreateObject("Bullzip.PDFPrinterSettings")

    obj.SetValue "Output" , pdfOutputFile

    obj.SetValue "ConfirmOverwrite", "No"

    obj.SetValue "ShowSaveAS", "never"

    obj.SetValue "ShowSettings", "never"

    obj.SetValue "ShowPDF", "no"

    obj.SetValue "RememberLastFileName", "no"

    obj.SetValue "RememberLastFolderName", "no"

    obj.SetValue "ShowProgressFinished", "no"

    obj.SetValue "ShowProgress", "no"

    obj.WriteSettings True

END FUNCTION

Appreciate your help.

Gaurav

529 Views
0 Likes
Not applicable
‎2012-09-20 02:40 AM
Author

In response to

Your security-settings in the macro ? (on the left)

529 Views
0 Likes
Not applicable
‎2012-09-20 07:19 AM
Author

In response to

GM,

you have to install Qlikview 32 bit and run QVW for him.

I had this same problem.

529 Views
0 Likes
Not applicable
‎2012-09-21 05:07 AM
Author

In response to

it is system access for both ;(

529 Views
0 Likes