Author: Ken Puls

Creating a cipher

This isn't a post specific to a computer technique, but it does relate to security. What the heck is a cipher, anyway, and why would I want one? As a matter of course, I teach every staff member this when

Read More »

Stripping data from an imported file

Most of us, when we start dabbling with Excel macros, probably take the following steps: Record code Begin to make minor edits to the code Eventually learn about loops and start using them everywhere Learn that loops are "expensive" and

Read More »

Excel 2007 Compatibility Checker

This is a pretty cool new feature in Excel 2007 that I think will pay some dividends to people. The main intention is to ensure that users working in 2007 files are notified when they'll lose functionality by saving back

Read More »

wks format gone in Excel 2007

This came as a bit of a surprise to me, but you can no longer open/save a file in the old Lotus wks format in Excel 2007. Most people probably won't care about this, but I create batches of journal

Read More »

Vendor credit terms

Today our A/P clerk came into my office with a letter from one of our suppliers.  The letter basically tells us that our credit terms are Net 30 days, and that our May 31 invoice is overdue. Upon emailing the

Read More »

Send Email Via Groupwise

Macro Purpose: This is a stand-alone routine that will allow a user to automate the process of sending an email via the Novell Groupwise email client using VBA. Examples of where this function shines: Assume that you want to email

Read More »