6 posts tagged with vba and Microsoft.
Displaying 1 through 6 of 6. Subscribe:

Learning to use VBA

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

How do I set up Auto BCC on a single Exchange account out of three, in Outlook 2010?

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 practice in implementing a two-part unique identifier?

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

Stupid Outlook! No cookie!

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

Stumped by VBA-ising an array formula in Excel

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

Turning a complex Excel spreadsheet with VBA functions into an online app

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

Page: 1