I can't claim the original idea for this article. The concept actually comes from Professional Excel Development, but I developed the code, such as it is here, on my own. The reason for this was because I couldn't find it in the book when I went looking for it, so I knocked up my own version, and decided to post that here.

This is kind of a neat little routine, which adds a "DebugMode" property to the ThisWorkbook module. It also checks the MS Office username every time someone opens the file, and if it's me, it asks me if I want to use Debugging Mode. ...

Introduction:
This is one of my favourite functions to use in my projects. While VB's standard GetOpenFilename works great if you are in the correct directory, this saves my users time as I can tell it exactly where I want the dialog box to start looking... a very handy thing if you are opening files from different paths. ...

Introduction
Every now and then, you may need to send an email from another application through Outlook. If you've ever thought about automating this process using Outlook 2000, Outlook 2002 or Outlook 2003, then no doubt you've run into the dreaded Outlook security prompt upon trying to send ...

This article contains code examples to reset some (but not all) of the default settings of PDFCreator.
...

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

...

This code replaces all external links with their values, changes the colour of the background cell (so that you can see where), and places the original link path in a comment. If a comment already existed, it appends the original comment content to the bottom of the comment, and changes the comment colour as well.
...

This article shows how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings. ...

What is "Binding"?
"Binding" is essentially the process of connecting to the object model of an application to make use of its objects, properties and methods. There are two methods to accomplish this: Early Binding and Late Binding. ...

Introduction:
This article contains an example of using late binding to create a new instance of Internet Explorer.

Please note that you can copy these code examples into any application that supports VBA, but the called application must be installed on your system for it to work. Just copy them into a standard module and run them. (No references need to be set in the Visual Basic Editor in order to make this code work.)

Create a New instance ...