macro question

[vikasmahajan]

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

[Miguel_Angel_Baeyens]

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

[vikasmahajan]

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

[Gysbert_Wassenaar · Accepted solution]

Try adding this line above the SaveAs line:

    XLApp.DisplayAlerts = False

[vikasmahajan]

Thanks Works..

[rohit214]

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