About Office Automation Limited

Office Automation Limited was an independent consultancy based in London, England, run by Stephen Bullen and specialising in application development using the Microsoft Office suite with a focus on Microsoft Excel.

Stephen has moved on in his career and is now an IT Project and Delivery Manager at HSBC. The Office Automation web site has been retained, to provide a number of helpful and interesting utilities, examples, tips and techniques to help in your use of Excel and development of Excel solutions.  These files can be found on the Excel, Excel MVP, Smart Indenter and VBE Tools pages of this site,

After a growing number of requests for updated versions of his tools, the popular Smart Indenter and VBE Tools have been rewritten as C# addins to work in both 32-bit and 64-bit version of Microsoft Office and are available to download from our sister site OfficeAddins.co.uk.

About Stephen Bullen

A graduate of Oxford University, Stephen has an MA in Engineering, Economics and Management, providing a unique blend of both business and technical skills. He is one of a handful of people worldwide to be awarded Microsoft's Most Valuable Professional award for his Excel skills and was given the prestigious MVP award every year from 1995 to 2005.

Stephen entered the banking sector in London, initially working on the trading floor at Barclays Capital writing pricing spreadsheets for the structured interest rates desk, then moving to Merrill Lynch, Bank of America and Credit Suisse as his career progressed. He can now be found at HSBC, where he is an IT Delivery and Project Manager for the Fixed Income business, ensuring the Front Office Risk and PnL systems evolve to meet the ever-changing needs of the business, markets and regulatory environment.

Stephen can be contacted at stephen@oaltd.co.uk and is on LinkedIn.

Books

Stephen Bullen co-authored Professional Excel Development (published by Addison-Wesley), in partnership with Rob Bovey and with contributions from John Green. The book is targeted at intermediate through to advanced Excel developers and aims to be the natural successor to the Excel 2002 VBA Programmer's Reference, John Walkenbach's Excel Power Programming with VBA and similar beginner to intermediate titles.

More information, including the Table of Contents, a synopsis of each chapter and three sample chapters can be found here.

Buy Professional Excel Development from Amazon.com or Amazon.co.uk.

Stephen Bullen co-authored the Excel 2002 VBA Programmer's Reference, (published by Wrox Press) with John Green and contributions from Rob Bovey and Robert Rosenberg. The book is targeted at beginner to intermediate Excel developers, who want to improve their VBA skills. Stephen wrote chapters on:
  • Developing Excel applications for international clients
  • Using Windows API functions in Excel
  • Excel and the Internet
  • Programming the Visual Basic Editor (VBE)
  • Automation Add-ins and COM Add-ins
  • Smart Tags

Buy your copy from Amazon.com or Amazon.co.uk and download the code samples from Wrox

More information, including the Table of Contents and a sample chapter (Chapter 22 - International Issues) can be found here.

Contact Information

E-mail: stephen@oaltd.co.uk