Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Training
    • Monkey Tools Add-in
    • Monkey Tools Account
    • Books & Other Products
    • Private Courses
    • 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
  • 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)
    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: 24332 

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

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

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

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

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

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

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

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

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

    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

    p45cal

    Change the Font Size on the displayed LOV

    In which case, best attach a file where this is happening (only showing a few cells behaving this way, maybe the macro trying to adjust the font, but...

    p45cal 2022-05-19, 06:44 PM Go to last post
    amyfb

    Change the Font Size on the displayed LOV

    oh, you had me all excited there for a minute, but, when I looked, the shrink to fit box is unchecked. I took off word wrap as well, just in case that...

    amyfb 2022-05-19, 06:35 PM Go to last post
    p45cal

    Change the Font Size on the displayed LOV

    Are you sure you don't have Shrink to fit on?:
    ...

    p45cal 2022-05-19, 03:03 PM Go to last post
    p45cal

    sumproduct formula or replacement

    Just out of interest, a shorter version of the formula in msg#1 for more recent versions of Excel:

    Code:
    =SUM((INDEX(I2:FD273,SEQUENCE(272),SEQUENCE(,51,1,3))="")*(INDEX(I2:FD273,SEQUENCE(272),SEQUENCE(,51,2,3))=FX13)*(C2:C273=FZ11))
    ...

    p45cal 2022-05-19, 02:51 PM Go to last post
    p45cal

    find the winner name from highest numbers

    In cell N3:

    Code:
    =IF(L3=MAX($L$3:$L$13),J3,"")
    O3:
    Code:
    =IF(L3=MAX($L$3:$L$13),K3,"")
    P3:
    Code:
    =IF(L3=LARGE($L$3:$L$13,2),J3,"")
    ...

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