Category Archives: Macro

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

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

Macro Enabled Purchase Order Template

There is a newer version of this template now available, here: http://stott.asia/macro-enabled-purchase-order-template-2/ I was asked to come up with a simple purchase order system for our team to use, which would hopefully automate the process a little. We needed: Unique … Continue reading

Posted in Macro, MS Excel | 10 Comments

Word VBA Macro > Create DOC to PDF & Email

A while back, I had a request to automate the way users can create a PDF file from MS Word, and attach it to an email – essentially create a Word to PDF macro, with automatic email creation. ¬†Currently their … Continue reading

Posted in Macro, MS Word, VBA | Tagged , , , | 10 Comments