Hello,
I tried a lot of posibilities, lot of hours... I have QV 11 (and Server, not Publisher), Win2003 Server x64, and I can automaticaly generate report into PDF.
I have BullZIP PDF and macro, which I red in many discussions:
Function PrintBullPDF (pdfOutputFile)
set obj = CreateObject("Bullzip.PDFPrinterSettings")
obj.Init
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
Sub PrintReport
vReport = "RP01" 'Set report
vName = "Test" 'Name of output pdf
reportFile = "c:\QVReportPDF\" & vName &".pdf" 'Setting outputname
PrintBullPDF(reportFile) 'Call pdf printer
ActiveDocument.PrintReport vReport, "BullzipPDF", false 'Printreport
ActiveDocument.GetApplication.Sleep 5000
End sub
Now I test in by button with running macro.
But QV create any report - after click QV opens Macro Editor, after few moments is open dialog for create PDF, but with standard settings (other filename, other checkboxes...)
Now I tried, if I create INI file runonce.ini manually or in separate running (.BAT), the print into PDF is succesfully. So I'm sure, the problem is: QV and VB macro don't create INI file.
I set Requested Module Security - System Access, Current Local Security - Allow System Access.
Please:
- how is possible debug macro? I dont understand, why click button open macro editor; I dont see some error, or window with message about problem...
- do you have any idea?
Thanks.
Olda
