I have just installed the latest version of PDF Creator. Now when I print documents from Word or Excel with paper size set to Letter, the PDF file created uses A4 paper size so the PDF documents have large top and bottom margins. I tried creating custom paper size in Word but still PDF were created with A4 size. Created PDFs in other programs like Paint and my text editor and the paper size is correctly set to Letter. Anyone have any suggestion as to how to get PDFCreator to create PDF documents in Letter paper size?
Hi - Same problem here: I just downloaded and installed PDFCreator 1.2.0 (on Win 7 Prof 64-bit) and tried printing from several applications. I got the correct page size except from MS Word and Excel 2003. Both applications were set for printing to letter size and PDFCreator (in advanced settings) also showed letter size but the resulting PDF page size was A4. The same document that produced an A4 size PDF file in Word gave a correct letter size PDF file when printed from Open Office.
I found a quick work-around: setting PDFCreator to have a fixed output size of 'letter' (set in options/program/document properties 2). Word and Excel then work correctly. I assume I can create a 2nd printer profile to handle non-letter-size output - haven't taken the time to figure that one out yet.
Overall this is an excellent program - as good as any commercial version I have seen - but this is an odd bug.
I wanted to thank you for posting this. I saw that the new version was translating the pdf output to an A4 document, but had no idea how to reset it to letter. It shouldn't be this cumbersome to change the output page size, but thanks again for explaining the quick fix for this.
It will certainly make me think twice in the future about upgrading from a product version that I was perfectly happy with.
(I thought that maybe a European developer was giving us Yanks a hard time. ;-)
I'm looking for a robust way to once and for all only print A4 PDF's from an Excel document, with help of VBA.
I'm an European user and actually here it's the other way around I get letters sized PDF's where I want A4. I found out several places to change the size of the paper but none of them seems very robust:
-Printer device settings within I have a choice to change personal settings and default settings
-option from pdfcreator itslef use fixed paper size
-Through VBA wher I use the coption ("papersize")= "A4"
I can get it to work one way or the other on my own machine. The only thing is I'm developing a procedure in VBA which will be used by several users on different machines and I don't have all the options above (or at least I cannot control them allways)
Which settings / parameters are essential to always print A4 sized PDF's
I managed to get a solution by using devmode type from winspool.drv within VBA calling the function setprinter and other procuderes form winspool.drv to change the printing preference into A4 (this is not a straight forward thing btw).
I know this an old thread, but I was messing around with this all morning and wanted to add my experience to this:
The previous user's suggestion of setting the cOptions papersize to Letter and then UseFixPaperSize to 1 worked.
However, it made my headers/footers disappear.
I couldn't find a way to get Letter to really work through VBA. But I was able to get it to always do Letter by going to my Control Panel->Printers->(Right Click)->Printing Preferences->Advanced and then setting it to Letter there.
Now all my documents print to Letter rather than A4. Apparently changing those options through VBA doesn't seem to ever work. But glad I found a workaround. I will just have to tell each of my users to do that to get it to work.