Tag Archives: VBA

Dumping file info into an Excel spreadsheet

So you’ve got a folder full of documents and you want to know what’s in the folder, how big the files are, and when they were last modified? And of course you want to be able to filter and sort … Continue reading

Posted in Excel, Microsoft, Programming | Tagged | Comments Off

Export Microsoft Outlook Journal entries to Excel

If you’re a Microsoft Outlook Journal user, save this code into a macro to export journal entries from a select time range into Excel. Updated for Excel 2007. In your macro window, under Tools>References, make sure you check the Microsoft … Continue reading

Posted in Excel, Outlook | Tagged , | Comments Off