I'm using PDF Creator within excel macro, but unfortunately print job always stuck in spooler. I don't know how to solve this. Please look at my macro below.
I always recieve PDF print but macro is unable to count it a finish procedure.
Also this one is working in excel 2007, but when I use it in 2003 it won't even PDF print out. This one work, but when I turn on Auto Save option, after execution nothing happens, it goes to spooler but without any print out.
I would appreciate if someone can help me to solve this.
Thanks in advance
PrintPDF.cPrinterStop = True
.cOption("UseAutosave") = 1
.cOption("UseAutosaveDirectory") = 1
.cOption("AutosaveDirectory") = SaveStr
.cOption("AutosaveFilename") = FName
.cOption("AutosaveFormat") = 0 ' 0 = PDF
ActiveWorkbook.Worksheets("PONUDA").PrintOut copies:=1, ActivePrinter:="PDFCreator"
Do Until PrintPDF.cCountOfPrintjobs = 1
PrintPDF.cPrinterStop = False
Do Until PrintPDF.cCountOfPrintjobs = 0
Set PrintPDF = Nothing