Category Archives: Templates

Macro Enabled Purchase Order Template

It’s been two years since I uploaded my Macro Enabled Purchase Order Template, and it’s been one of the most popular pages & downloads on my site to date…. I’ve recently updated this to fit some new requirements & I … Continue reading

Posted in Macro, MS Excel, VBA | 2 Comments

System Uptime / Availability Calculator Template

I created this System Uptime / Downtime / Availability Calculator Template as an easy way to work out the effect of any outage on our Service Level Agreements. This template is using Australian sites & timezones as this was what … Continue reading

Posted in MS Excel | Tagged , , , , , , | 1 Comment

Excel VBA Macro > Create XLS to PDF & Email

This is the Excel version of a previous post, Word VBA Macro > Create DOC to PDF & Email, to allow you to automatically generate a PDF attachment to a draft message in Outlook with a custom filename, from the … Continue reading

Posted in Macro, MS Excel, VBA | Tagged , , , | 1 Comment

Add a Reference To The Microsoft Office Object Library

Here are some steps to follow, to allow you to add a reference to the Microsoft Office Object Library from within Excel. Steps 1, 2 & 3 can be skipped via ALT+F11, but it’s handy to have the developer tab added for … Continue reading

Posted in MS Excel, VBA | Tagged , , , , | Leave a comment