Module Name

Formatter for MS Project Export (WBS) - Updated

This is an updated version of prior code. With this, I have improved on several aspects:
Note, as always, use at your own risk, and make sure you review the code before using it.

Formatter for MS Project Export (WBS)

Although I am just starting to work more in MS Project, hence will likely develop code to enhance my productivity in a PM role, this is the first attempt.
Note, as always, use at your own risk, and make sure you review the code before using it.

Structured Interview Template

Some basic elements useful for a structured interview for a developer or a project manager.

20 Cognitive Biases That Affect Your Decision-Making

We all make bad decisions sometimes, but have you ever wondered what mental obstacles can lead you astray? This infographic goes over 20 of the most common cognitive biases that can mess with your head when it’s decision time.
Gantt Charting Template.xlsx

Gantt Charting Template

A simple template for Gantt charting, with two examples:

Requirements Template

A general documents with areas to describe various facets of requirements analysis

JavaScript API for Office (PNG)

The JavaScript API for Office includes objects, methods, properties, events, and enumerations that you can use in your apps for Office code.

The Microsoft.Office.WebExtension namespace (which by default is referenced using the alias Office in code) contains objects you can use to write script that interacts with content in Office documents, worksheets, presentations, mail items, and projects from your apps for Office.

Business Model Canvas

When founders are getting started with the Canvas, they tend to focus on the right side. And rightly so, Blank notes—that’s where product/market fit will unfold. But it’s the oft-neglected left side of the canvas that will tell you what your founding team should look like. On a successful Canvas, the two sides should mirror each other; the right is all about customers, and the left tells you what you need to reach them.

Filling in the Canvas is level one. But understanding the interplay of the boxes takes you to level two. That’s when your Canvas goes from a checklist to a strategy.

Finding the right co-founder is one of the most instrumental pieces of that strategy. Start by looking carefully at your Key Activities box. Of the nine modules on the Canvas, it most defines what you need to do to build your product and deliver it successfully to consumers. Then jump down to the next box labeled Key Resources, where you’ll list what’s required to execute those activities. Is there a gap between what you’re going to need and what you bring to the table yourself? That delta reveals the expertise you need to find in your co-founder.

Powershell File Rename

As the name says, the basic components of a folder's files renaming...

Adobe JavaScript Automation in VBA

Example VBA code for working with Adobe Acrobat in VBA, with some of the following features:


Get File Owner with PowerShell

A basic script to derive the owner of a file using, along with othe rinformation

Pastel Blocks for Canvas (Javascript, HTML/PHP, CSS)

Four files, one for the js, one for the CSS, one for Modernizr, and one for the HTML/PHP, that work together to create dynamic, rectangle layouts in a canvas.

The original code was inflexible, with hard-coded height, width, and rectangle number, from which I changed to an object, and one that has a constructor with parameters.

I primarily work in VBA, C# and SQL, but some of my websites are PHP/HTML. I wanted to spruce it up a bit, and here is the site and the result of the javascript.

Working with CustomXmlPart (C#)

This C# code shows the basics of working with CustomXmlParts of the Office 2007 and greater environment. It is a way to store complex information within workbooks. In this example, I create a type, and the create XML to stores the type, and then either set, or retrieve the XML.

Working with CustomXmlPart (VBA)

This code shows the basics of working with CustomXmlPart of the Office 2007 and greater environment. It is a way to store complex information within workbooks. In this example, I create a type, and the create XML to stores the type, and then either set, or retrieve the XML.

Send Excel Range as Image (VBA)

VBA code to send a selected Excel range as an image via Outlook email

Various Number Functions (F#)

A collection of basic mathematical functions written in F# as part of my learning via Project Euler. This module has functions for creating arrays or calculating values for the following:

Basic Statistical Functions (F#)

A very basic F# class for performaing standard deviation and variance calculations.

Competency Matrix for VBA

A developer, Sijin Joseph, reachable @, has an online Programmer Competency Matrix, which I have taken and converted to Excel.

Project Euler Language Stats (Excel 2003/2007)

An alternative ranking to Project Euler's stats (Excel 2003/2007), creating a sortable lists from language rankings.

SMTP Addreses from Outlook (C#)

This is C# WinForm code that demonstrates using Outlook (requires a third-party COM product called Redemption) to get at the SMTP addresses from the outlook address book. It takes about 60 minutes to output a file, also attached, of ~160k users and their SMTP address, but it shows the basics of the process. This is not likely appropriate for server use. Below is the code, but an easier solution might simply be for the code sending the email to iterate through the list and send an email to each person, and record failure for any particular address

COM Memory Cleanup for Office Interop (C#)

Helper code for cleanining up memory when working with Excel in .NET (COM Object)

Design Pattern List (Updated)

An updated list of design patterns covering ideas laid out by the GoF, Code Complete, Pattern-Oriented Software Architecture, and Patterns of Enterprise Application Architecture.

CellSet, DataTable, Recordset Conversion (C#)

This C# code that generates a cellset from MDX, transforms it into a datatable, tranforms that into an ADODB recordset, and then creates a pivotcache/pivottable from the recordset. It gets around the inability of Excel 2003/2007 to create pivot tables directly from MDX.

Working with Document Properties (VBA)

Code module for working with document properties. Original code is from Pearson's website, with some modifications by myself.

Access VBA Modules from forms, that show how to retrieve domain-related information. These are provided as examples, since you will need to decouple the code from the underlying tables and related forms to use them.

Design Patterns

An Access DB that queries the domain for object, e.g., user ID's. Requires that you modify code to specify a domain The code can be run from the supplied form or directly, and truncates and appends to the supplied table. Please note, this was last edited in Access 2007, and if you are using an earlier version, you will need to correct broken references.

A function that sends (no prompt) a Notes e-mail, based on passed values for subject, recipient, body, and attachment.

in SMS, a simple graphical interface for installations. Once compiled, one only need modify the INI file with application information, path information, and EXE name. The EXE and INI should be located in the same directory.

Query Active Directory (AD) for User Information

A VBScript that requests UserID information from a domain, which you will need to specify. Please note, this file is stored as a ZIP file.