Category: VBA

Printing Multiple Word Documents to a Single PDF

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

RibbonX – Customizing the Office 2007 Ribbon (Wiley Publishing)

I'm very pleased to be able to share a Chapter from my new book, RibbonX - Customizing the Office 2007 Ribbon. This chapter discusses the comboBox and dropDown RibbonX elements in detail. From using Microsoft's built in elements to creating

RibbonX Chapter 7 Available

I have now posted a copy of Chapter 7 of the RibbonX book. You can find it here. 🙂

An Excerpt from RibbonX – Customizing the Office 2007 Ribbon

I'm very pleased that Wiley Publishing has encouraged me to post an excerpt from our new book RibbonX - Customizing the Office 2007 Ribbon, which can now be found at Amazon.com and other online retailers. Chapter 2 of the book

Print To PDF Using Microsoft’s PDF/XPS Add-in

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

Office PDF/XPS Addin

One of the big things that Office 2007 was supposed to bring was the ability to save to a PDF file, without getting extra software. Somewhere along the line, they decided to make this feature an Add-in, which can be

Force User To Enable Macros

Introduction: There are times when you may need to force your users to enable macros to work with your files. Maybe you've programmed some special functions to work with your file, for example. Unfortunately, Office's security settings can get in

My code has been used by NASA…

Now this is straight out of the "How cool is that?" file. 🙂 Last week, I got an email asking a question about adapting the Print Multiple Worksheets to a PDF article that I have on my site so that

Error Messages: Can’t Initialize PDFCreator

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. What is happening? At the end of the PDFCreator routines on this site, we release

Using a Treeview Control

This is a tutorial on the creation of a simple Treeview control on an Excel userform. For the purposes of this example, we'll be populating the Treeview control with worksheet names and the addresses of cells with formulas in them.