Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PDFCreator code
Hi, I'm using the following code. It works, but every now and then PDFCreator
is left running and fails the next time until I kill it through the task manager. This is not very practical because I have massive macros that run PdfCreator several times and then email out the pdf, so I get crashes. Do Until pdfjob.cCountOfPrintjobs = 0 DoEvents Loop Application.Wait Now + TimeValue("0:0:10") pdfjob.cClose Set pdfjob = Nothing Application.ActivePrinter = printer_memory You'll note the huge wait time that I have to put in to restrict this problem. Is there another way of killing the application first before using it again? Thanks, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Problems with PDFCreator | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |