文档介绍：Excel® 2007 VBA
Macro Programming
About the Author
Richard Shepherd has worked for many years for major banks and corporations in the
United Kingdom writing spreadsheet macros to solve specific problems. He has worked for
National Grid plc (electricity distribution), Hertz Car Leasing, NatWest plc (retail banking),
Schroders plc (fund management), BNP Paribas (investment banking), Lloyds TSB plc
(corporate banking), The Royal Bank of Scotland plc (investment banking), and the British
National Health Service.
He has developed advanced spreadsheets and macros for budgeting, business planning,
and profit and loss reporting. He originally started working with Lotus 123 spreadsheets
but moved some years ago to Microsoft Excel and Microsoft Access. He qualified as an
accountant with the Chartered Association of Certified Accountants in 1976 and has been
a Fellow since 1981.
He can be contacted at tollside@, but he cannot promise to answer every
e-mail!
About the Technical Editor
Todd Meister has been developing using Microsoft technologies for over ten years. He’s
been a technical editor on over 50 titles ranging from SQL Server to the .NET Framework.
Besides technically editing titles, he is an assistant director puting Services at Ball
State University in Muncie, Indiana. He lives in central Indiana with his wife, Kimberly, and
their four remarkable children.
Excel® 2007 VBA
Macro Programming
Richard Shepherd
New York Chicago San Francisco
Lisbon London Madrid Mexico City Milan
New Delhi San Juan Seoul Singapore Sydney Toronto
Copyright © 2010 by The McGraw-panies. All rights reserved. Except as permitted under the United States Copyright Act of 1976,
no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without
the prior written permission of the publisher.
ISBN: 978-0-07-162701-6
MHID: 0-07-162701-4
The material in this eBook also appears in the prin