Tag Archives: Macro

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

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