Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Monkey Tools Add-in
    • Books & Other Products
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • 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 07:40 AM     Number of Views: 23385 

    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 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 06:24 AM     Number of Views: 48899 

    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 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 06: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 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 06:38 AM     Number of Views: 27845 

    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 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 07:17 AM     Number of Views: 34446 

    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 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 06:18 AM     Number of Views: 14574 

    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 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 08:06 AM     Number of Views: 25771 

    This article contains code examples to reset some (but not all) of the default settings of PDFCreator.
    ...
    Read More 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 06:32 AM     Number of Views: 26828 

    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 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 08:01 AM     Number of Views: 31287 

    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 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 07:04 AM     Number of Views: 45492 

    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 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 04:48 AM     Number of Views: 172941 

    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 Read More 28 Comments
  • MVP Logo
  • Recent Forum Posts

    AliGW

    Specification Comparison Table from Different Worksheets

    And here it is!

    I suggest you print out and read through the instructions BEFORE attempting anything. PQ is easy once you get the hang of...

    AliGW Today, 03:04 PM Go to last post
    Polignac

    Specification Comparison Table from Different Worksheets

    Thanks Ali! Looking forward to it! ...

    Polignac Today, 02:06 PM Go to last post
    AliGW

    Specification Comparison Table from Different Worksheets

    I believe I have now resolved the issues. I will post a How To ... within a couple of hours. ...

    AliGW Today, 01:31 PM Go to last post
    AliGW

    Specification Comparison Table from Different Worksheets

    Did you see the post I just made? Sorry, but I've had to withdraw the solutions offered....

    AliGW Today, 11:28 AM Go to last post
    Polignac

    Specification Comparison Table from Different Worksheets

    No worries. I appreciate your help on this. ...

    Polignac Today, 11:27 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 04:28 PM.
Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it