Author Archives: Nick

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


Well, here’s some music I’ve made over the last 10 years or so. You might like it, you might hate it… it’s all gravy baby. Some free 320 MP3’s for your musical pleasure, drum & bass & electro. Will add … Continue reading

Posted in Music | 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

SharePoint 2010 – Drop Off Library Not Indexed For Searching

After patching our SharePoint 2010 farm to SP1 & the Feb 2013 CU, we noticed that our drop off library was no longer being indexed for searching…. The configured crawls were taking place, but new items were no longer showing in the … Continue reading

Posted in SharePoint | Tagged , , , | Leave a comment