Excelguru.ca - Powered by vBulletin
  • Register
  • Help
  • The Facebook Platform

  • Knowledge Base
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
  • Forum Tools
    • What's New?
    • Today's Posts
  • Courses
    • Excelguru e-Learning Catalog
    • The Magic of PivotTables (2003)
    • The Magic of PivotTables (2007)
    • The Magic of PivotTables (2010)
    • Instructor Led Training
    • Sell Excelguru Courses On Your Site
  • Resources
    • Excelguru e-Learning Catalog
    • Books
    • Charting & Dashboarding Resources
    • Useful Add-ins and Tools
    • Other Forums
    • Excel Blogs
    • Useful Links
    • Excel Training Calendar
    • Consulting
    • Sales Affiliate Program
  • FAQ
    • FAQ Index
    • General Forum Usage
    • Reading and Posting Messages
    • Supported BB Code Tags
    • Multi Forum Posting Policy
  • About
    • About Me
    • Awards
    • Testimonials
    • Contact Me
  • 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.

  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (6)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (11)
    Excel - PowerPivot (6)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (48)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (0)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (3)
    Word - VBA Programming (8)
  • Learn how to create Excel dashboards.
  • 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: 5871 

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

    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

    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".

    ...
    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: 4375 

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

    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 3 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: 2408 

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

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

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

    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

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

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

    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 1 Comment
  • MVP Logo
  • Recent Forum Posts

    salgunaidi

    Creating formulas & Macros

    Hey thanks for your efforts.

    I think we are nearly there, however in the 'date required' filed I would like to be able to manually type...

    salgunaidi Yesterday, 11:48 PM Go to last post
    JeffreyWeir

    Solve the matrix

    Maths was never my thing, I'm afraid. I'm sure a google search will turn up the answer....

    JeffreyWeir Yesterday, 10:49 PM Go to last post
    JeffreyWeir

    VBA Program to Compare 4 Columns in Excel (Required)

    Hi vijaysram. Note that iterating through a long list using this code would take quite a bit of time, and that there are a few other approaches that will...

    JeffreyWeir Yesterday, 10:47 PM Go to last post
    balla506

    Create Subfiles from a master file using key to split workbooks to seperate files

    Here it is. I modified very slightly and just regular characters. It does cause the error I've been getting. Thanks....

    balla506 Yesterday, 09:30 PM Go to last post
    NoS

    Create Subfiles from a master file using key to split workbooks to seperate files

    I'm not having any success trying to duplicate that error.
    Could you possibly post the workbook you're using when this is happening?...

    NoS Yesterday, 08:57 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 12:07 AM.
Powered by vBulletin® Version 4.2.0
Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Thread / Post Bookmarking by Thread / Post Bookmarking v1.1.0 - vBulletin Mods & Addons Copyright © 2013 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Copyright © 2004-current by Ken Puls
Gravatar by 1e2.it