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 08:40 AM     Number of Views: 23165 

    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 07:24 AM     Number of Views: 48367 

    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 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 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: 27471 

    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 08:17 AM     Number of Views: 33956 

    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 07:18 AM     Number of Views: 14360 

    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 09:06 AM     Number of Views: 25507 

    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 07:32 AM     Number of Views: 26516 

    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 09:01 AM     Number of Views: 30609 

    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 08:04 AM     Number of Views: 45067 

    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 05:48 AM     Number of Views: 169523 

    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

    rj1600

    Macro that concatenates two cells, references a Date and then copy pastes value into

    Would love some help writing this macro
    i tried attaching a file with more explanations within the file if it helps make it clearer. (in yellow...

    rj1600 Today, 03:08 AM Go to last post
    lmuhr

    load, transform and combine multiple tables

    I am trying to combine data from tables (formatted as tables) that have identical structures. there are multiple tables per sheet and multiple sheets...

    lmuhr Yesterday, 11:14 PM Go to last post
    AliGW

    Display a list of columns if data is present within?

    Administrative Note:


    Welcome to the forum.


    We would very much like to help you with your query, however it...

    AliGW Yesterday, 10:04 PM Go to last post
    ExcelHelpNecessary

    Display a list of columns if data is present within?

    I have a table with the following data:

    Rows: Names of People
    Columns: Fruits

    Is there anyway to set up a dropdown list...

    ExcelHelpNecessary Yesterday, 08:21 PM Go to last post
    MsDavid

    Create Multiple Pivot tables automatically or quickly

    Hello,
    This question is posted on another forum as well (link above). I am still looking for an answer so any help would be much appreciated. ...

    MsDavid Yesterday, 10:14 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 08:36 AM.
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