Category: Excel

Deploying Add-ins in a Network Environment

Introduction The purpose of this article is to provide corporate developers with a method to release, maintain and update an add-in in a network environment. This is based upon my strategies for doing this same. Assumptions made in this article

Read More »

Send Email Using ClickYes

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

Read More »

Print To Picture Using PDFCreator

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.

Read More »

Resetting PDFCreator Options via Code

This article contains code examples to reset some (but not all) of the default settings of PDFCreator. These code examples are built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions

Read More »

Using PDFCreator with security options set

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 These

Read More »

A message to forum cross posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online

Read More »

Restore Default Comment Colour

Restores default yellow colour for all comment on the worksheet. Can easily be modified to change all comments to a different colour by changing the value of the lDefaultCommentColor variable. Where to place the code: This code goes in a

Read More »

Replace External Links With Values

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

Read More »

Spreasheet Design Tips

There are three types of spreadsheets built in the world today: The "quick 'n' dirty for your eyes only" type spreadsheet. It doesn't need to be pretty, and doesn't need a ton of time spent making it readable or understandable

Read More »