topic Re: macro question in QlikView

macro question

vikasmahajan — Thu, 02 May 2013 12:15:40 GMT

Dear All

I have following macro to export qlikview object into excel but it as me

save as dialog how do I avoid this saveas dialog in macro.

Thanks in advance

Vikas

Re: macro question

Miguel_Angel_Baeyens — Thu, 02 May 2013 12:26:29 GMT

Hi,

First, make sure the macros are allowed to access the filesystem in the Control + M macro editor dialog, bottom left hand side.

Second, make sure the UAC is disabled in the computer where you try to export, and that the file does not exist already, otherwise the macro should replace the file instead of just saving it.

Hope that helps.

Miguel

Re: macro question

vikasmahajan — Fri, 03 May 2013 09:42:47 GMT

Dear Miguel,

Thanks for Reply Please see the attached file showing dialog box while exporting macro I want to bypass

this system should overwrite file

any option to set ?

Regards

Vikas

Re: macro question

Gysbert_Wassenaar — Fri, 03 May 2013 10:07:38 GMT

Try adding this line above the SaveAs line:

XLApp.DisplayAlerts = False

Re: macro question

vikasmahajan — Fri, 03 May 2013 10:33:23 GMT

Thanks Works..

Re: macro question

rohit214 — Fri, 05 Dec 2014 11:59:58 GMT

Hi,

What should i need to write for pdf , in place of XLapp?

I have Adobe Acrobat X standard for generating my PDF and my macro script is

sub printRP01

printReportPDF "C:\Users\rgupta27\Desktop\New folder\DWR.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP01", "QlikViewPDF"

ActiveDocument.PrintReport "RP02", "DWR"

ActiveDocument.GetApplication.Sleep 10000

ActiveDocument.PrintReport pdfOutputFile, "QlikViewPDF", True

end sub

Function printReportPDF(pdfOutputFile)

Set WSHShell = CreateObject("WScript.Shell")

WSHShell.RegWrite "HKCU\Software\QlikViewPDF\OutputFile", pdfOutputFile, "REG_SZ"

WSHShell.RegWrite "HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"

Set WSHShell = nothing

End function

Regards

Rohit