PDF Creator 2.1 Excel VBA Conversion

PDFCreator PDFCreator English
1

Hey there,


Our company recently upgraded all of our machines to Version 2.1 and this has caused a problem in many of our custom VBA modules in excel. I am attempting to convert the previous code to version 2.1 but I keep on running into problems with initializing the pdf creator queue. I cannot release the COM object with ReleaseCOM command. Therefore once the code runs once with the JobQueue.Initialize function I cannot cancel it or even create an error handling statement. 

I’m sure there are many others out there having similar problems so if we could get some example VBA code other than those provided in the how to section it would be very helpful. I have referenced those examples and they do not help me with this problem. If your going to supply the same answer I’ve seen in many other forum posts that more will be released with the next version as it is still in BETA… Could you at least tell us when we should be expecting this to be released?
2
Answer Found

The initialize error occurs when working on the VBA program when the script errors on a pdf creator statement. ReleaseCOM doesn't work when it errors out there because it is essentially stuck.The only solution I found when working on it was to close out of the excel instance completely. Anyways I managed to get it to function in VBA. The how to examples have the solution in them in the version 2.1 manual but heres where I got tripped up.

Once your script has printed all the pages you want run the following:
   With PdfCreatorQueue
        .NextJob
        .NextJob.ConvertTo (file_name)
End With
'ConvertTo essentially means print the job which was the main part I was missing.
3

and by printed all the pages I mean Queued all the pages