I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes on Apr 6, 2013 - 3 answers

I need to Auto BCC myself on all mail I send through Outlook 2010 from one (and only one) of my Exchange accounts. How can I do this? [more inside]
posted by zarq on Jan 2, 2012 - 2 answers

Best way to implement a two-part unique identifier in Access? [more inside]
posted by jsturgill on May 9, 2011 - 14 answers

VBA programmers: is there any way to control the formatting of Outlook Contacts Body text? [more inside]
posted by IAmBroom on Feb 2, 2009 - 0 answers

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers