Excelguru Help Site - PDF Creator

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (9)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (12)

Excel - Power Query (3)

Excel - PowerPivot (7)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (49)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (1)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

Power BI (3)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (10)

Word - VBA Programming (8)

PDF Creator - VBA Programming
Printing Multiple Word Documents to a Single PDF

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2008-01-22 08:40 AM Number of Views: 19007

This article contains code which will print all open Word documents into a single PDF file.

These code examples are built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. Please note that this code will NOT work with Adobe Acrobat. ...

Read More
Print To PDF Using Microsoft's PDF/XPS Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2008-01-04 07:24 AM Number of Views: 41308

Introduction:
This article contains code that can be used to print worksheets or entire workbooks to a PDF file, using Microsoft's free Save as PDF or XPS add-in for Office 2007. These routines will NOT work in versions of Office prior to 2007. If you are running an earlier version of Office, and are running on Windows XP, then have a look at my PDF Creator articles.
...

Read More 3 Comments
Error Messages: User-Defined Type Not Defined

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2007-03-02 07:27 AM

There are a great many errors that we can run into when programming, and just on of those is a Compile Error, specifically "User-Defined Type Not Defined".

This error could mean one of a few different things, which may not all be listed here. Two of the most common, ...

Read More
Error Messages: Can't Initialize PDFCreator

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2007-02-20 07:38 AM Number of Views: 22109

A problem than can occur when working with PDFCreator via code is that sometimes the code releases PDFCreator too early, and it isn't properly closed. ...

Read More
Printing Access Reports To A PDF File

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-09-29 08:17 AM Number of Views: 27583

This article contains code examples to print a Microsoft Access report to a PDF file.

This code examples is built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. Please note that this code will NOT work with Adobe Acrobat. ...

Read More 5 Comments
Print To Picture Using PDFCreator

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-06-24 07:18 AM Number of Views: 10366

This article contains code examples to print worksheets to PDF files in a picture format, including: pdf, png, jpg, bmp, pcx, tif, ps (postscript), eps and txt.

This code example is built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. Please note that this code will NOT work with Adobe Acrobat.
...

Read More
Resetting PDFCreator Options via Code

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-06-23 09:06 AM Number of Views: 19873

This article contains code examples to reset some (but not all) of the default settings of PDFCreator.
...

Read More
Some Notes On Developing With PDFCreator

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-06-15 07:32 AM Number of Views: 21236

During my course of experimenting with PDFCreator, I ran into a few interesting things. In an effort to help any of you who decide to adapt this to your own use, I thought I'd share those here. ...

Read More
Using PDFCreator with security options set

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-06-09 09:01 AM Number of Views: 24500

This article shows how to use PDFCreator to make a PDF that leverages some of their security features. Specifically, we'll create a file that uses:

A "File open" password
128 bit encryption
Preventing content copying
Preventing modification
Preventing printing

...

Read More 3 Comments
Printing Worksheets To A PDF File (Using Late Binding)

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-04-11 08:04 AM Number of Views: 39122

Introduction:
This article contains code examples to print worksheets to PDF files, using PDFCreator.

These code examples are built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. Please note that this code will NOT work with Adobe Acrobat.
...

Read More
Printing Worksheets To A PDF File (Using Early Binding)

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-04-11 05:48 AM Number of Views: 145869

Introduction:
This article contains code examples to print worksheets to PDF files.

These code examples are built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. Please note that this code will NOT work with Adobe Acrobat. ...

Read More 28 Comments

Recent Forum Posts
sort single row/multiple columns

Is there a way to sort a portion of a single row over multiple columns, without having to specify a Sort by column?

I have individual words...
r121a947 Today, 02:28 PM
Find Replace and Update

Code:

let Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

...
Bob Phillips Today, 12:34 AM
Find Replace and Update

Hello Everyone,

New user here, I am trying to do the following between two tables that have several thousand lines.

I have...
CrazyMexican Yesterday, 10:33 PM

workload allocation w/ skills matrix

Cross-posted (and answered) at: https://chandoo.org/forum/threads/wo...-matrix.43173/
Also cross-posted at:
https://www.excelforum.com/excel-pro...ls-matrix.html...
macropod 2019-12-05, 09:40 PM

Remove duplicate cell value and not the actual cell.

If you just don't want to see the value, you could use conditional formatting over A1:A11 with a formula of =COUNTIF($A$1:$A1,$A2) and set the font colour...
Bob Phillips 2019-12-05, 05:22 PM

Knowledge Base Articles By Category

PDF Creator - VBA Programming

Recent Forum Posts