Tag Archives: Excel

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