Excel 2007 VBA Programmer's Reference (Programmer to Programmer)
Language: English
Published by Wrox, 2007
- Softcover
- Used
Seller: medimops, Berlin, Germanymedimops
AbeBooks seller since May 10, 2010
Condition: Used - Good
US$ 18.98
Quantity: 1 available
Add to basketItem description from seller
Befriedigend/Good: Durchschnittlich erhaltenes Buch bzw. Schutzumschlag mit Gebrauchsspuren, aber vollständigen Seiten. / Describes the average WORN book or dust jacket that has all the pages present.
Seller Inventory # M00470046430-G
- Title
- Excel 2007 VBA Programmer's Reference (Programmer to Programmer)
- Author
- John Green
- Publisher
- Wrox
- Publication year
- 2007
- Condition
- good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 0470046430
- ISBN 13
- 9780470046432
The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help.
The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency―that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.
The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).
"Synopsis" may belong to another edition of this title.
About the Author
He wrote his first programs in FORTRAN, took a part in the evolution of specialized planning languages on mainframes and, in the early ‘80s, became interested in spreadsheet systems, including 1-2-3 and Excel.
John established his company, Execuplan Consulting, in 1980, specializing in developing computerbased planning applications and in training. He has led training seminars for software applications and operating systems both in Australia and overseas.
John has had regular columns in a number of Australian magazines and has contributed chapters to a number of books including Excel Expert Solutions and Using Visual Basic for Applications 5. He also co-authored Professional Excel Development with Stephen Bullen and Rob Bovey.
From 1995 to 2005 he was accorded the status of MVP (Most Valuable Professional) by Microsoft for his contributions to the CompuServe Excel forum and MS Internet newsgroups.
John Green contributed the Introduction, Chapters 1–11, 13, 15–17, and 19 to this book.
Stephen Bullen lives in Woodford Green, London, England, with his partner Clare, daughter Becky, and their dogs, Fluffy and Charlie. He has two other daughters, Jane and Katie, from his first marriage.
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 has been providing Excel consulting and application development services since 1994, originally as an employee of Price Waterhouse Management Consultants and later as an independent consultant trading under the names of Business Modelling Solutions Limited and Office Automation Limited. Stephen now works for Barclays Capital in London, developing trading systems for complex exotic derivative products.
The Office Automation web site, www.oaltd.co.uk, provides a number of helpful and interesting utilities, examples, tips and techniques to help in your use of Excel and development of Excel applications.
As well as co-authoring previous editions of the Excel VBA Programmer’s Reference, Stephen co-authored Professional Excel Development.
In addition to his consulting and writing assignments, Stephen actively supports the Excel user community in Microsoft’s peer-to-peer support newsgroups and the Daily Dose of Excel blog. In recognition of his knowledge, skills and contributions, Microsoft has awarded him the title of Most Valuable Professional each year since 1996.
Stephen Bullen contributed Chapters 14, 18, 24–27, and Appendix B to this book.
Rob Bovey is president of Application Professionals, a software development company specializing in Microsoft Office, Visual Basic, and SQL Server applications. He brings many years’ experience creating financial, accounting, and executive information systems for corporate users to Application Professionals. You can visit the Application Professionals web site at www.appspro.com.
Rob developed several add-ins shipped by Microsoft for Microsoft Excel and co-authored the Microsoft Excel 97 Developers Kit and Professional Excel Development. He earned his Bachelor of Science degree from The Rochester Institute of Technology and his MBA from the University of North Carolina at Chapel Hill. He is a Microsoft Certified Systems Engineer (MCSE) and a Microsoft Certified Solution Developer (MCSD). Microsoft has awarded him the title of Most Valuable Professional each year since 1995.
Rob Bovey contributed Chapters 20–22 to this book.
Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than 14 years’ experience consulting and developing office solutions. He parlayed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently lives in Frisco, Texas, where he serves as a Senior Program Manager for a top technology firm. Michael is the author of several books on Microsoft Access and Excel, and is the principle behind DataPig Technologies, where he shares Access and Excel knowledge with the Office community.
Michael Alexander contributed Chapters 12 and 23 and Appendices A and C to this book.
"About the title" may belong to another edition of this title.
Shipping rates from Germany to U.S.A.
| Item | 10 to 20 business days | 10 to 20 business days |
|---|---|---|
| First item | US$ 11.61 | US$ 23.22 |
Payment methods
Store description
**WILLKOMMEN** im AbeBooks Shop von medimops - dein Onlineshop mit der größten Auswahl an Second Hand Büchern. Stöber dich durch über 4 Millionen Artikel und spare bis zu 70 % im Vergleich zum Neupreis. Wir prüfen alle Artikel sorgfältig auf Qualität und Funktionalität. **WELCOME** to the medimop's AbeBooks shop, the online shop with a large range of second-hand books. Browse more than 4 million articles and save up to 70% on the new price. All our articles are quality checked. ** BIENVENUE ** dans la boutique AbeBooks de momox shop! Spécialiste des articles culturels d'occasion, nous vous offrons une gamme diversifiée de livres d'occasion. Découvrez nos offres et économisez jusqu'à 70% du prix neuf! Nous grarantissons tous nos articles en bon état. ** BENVENUTI ** nello shop medimops di AbeBooks, lo shop online per i libri usati. Abbiamo piu´di 4 milioni di articoli e potete risparmiare fino al 70% rispetto al nuovo. Tutti i nostri prodotti sono controllati a mano per garantire la massima qualità. ** BIENVENIDO ** a la tienda de medimops en AbeBooks, la tienda online con una gran oferta de libros de segunda mano. Navegue por más de 4 millones de artículos y ahorre hasta un 70% sobre el precio nuevo. Todos nuestros artículos son de calidad comprobada. …
Seller's business information
momox SE
Schreiberhauer Straße 30
Berlin, Germany 10317
Terms of sale
1. Scope
For all orders via our store on the AbeBooks Marketplace, the following terms and conditions apply. Unless otherwise agreed, the inclusion of any terms and conditions of your own used by you is contradicted.
2. contracting party, conclusion of contract, correction options
The purchase contract is concluded with momox SE.
The subject of the contract is the sale of goods.
If an article is posted by us on AbeBooks, the activation of the offer page on AbeBooks is the binding offer to conclude a contract under the conditions contained in the article page.
The presentation of the products in the online store does not constitute a legally binding offer, but a non-binding online catalog. You have the option to complete the ordering process via the shopping cart system or the buy now function. You can initially place our products in the shopping cart without obligation and correct your entries at any time before submitting your binding order by using the correction tools provided and explained for this purpose in the order process. By clicking the order button you make a binding offer for the goods contained in the shopping cart. By pressing the button "Buy now" an order is automatically created, which will be sent to the delivery address you have provided and for which a payment is made with the specified payment method.
The confirmation of receipt of your order will be sent by e-mail immediately after sending the order. We accept your order within 2 days by us or AbeBooks on our behalf submitting/issuing a declaration of acceptance or shipping confirmation in a separate email or, if applicable, the payment transaction is carried out by the service provider or the selected payment service provider. The time of execution of the payment transaction depends on the respective selected payment method (see under "Payment"). The relevant alternative for you depends on which of the listed events occurs first.
3. contract language, contract text storage
The language(s) available for the conclusion of the contract: German
We store the text of the contract on our systems, which, however, are not accessible to you.
However, you have the possibility to view your last orders via your AbeBooks account. The full text of the contract is not accessible there.
4. delivery conditions
Shipping costs will be added to the indicated product prices. You can find out more about the amount of the shipping costs at the offers.
5. payment
The payment processing is done by AbeBooks. You can pay the invoice amount by credit card.
6. retention of title
The goods remain our property until full payment.
7. transport damage
If goods are delivered with obvious transport damage, please complain about such defects to the deliverer as soon as possible and contact us immediately. Failure to make a complaint or contact us has no consequences for your legal claims and their enforcement, especially your warranty rights. However, they help us to be able to assert our own claims against the carrier or the transport insurance.
8. warranty
The statutory liability for defects shall apply.
Customer service: Phone number: 0049 (0) 30/488288200
9 a.m. to 6 p.m., e-mail: service@momox-shop.uk
9. liability
For claims based on damage caused by us, our legal representatives or vicarious agents, we shall always be liable without limitation - in the event of injury to life, limb or health - in the event of intentional or grossly negligent breach of duty - in the event of warranty promises, insofar as agreed, or - insofar as the scope of application of the Product Liability Act is opened. In the event of a breach of essential contractual obligations, the fulfillment of which is a prerequisite for the proper execution of the contract and the observance of which the contractual partner may regularly rely on (cardinal obligations) due to slight negligence on our part, on the part of our legal representatives or vicarious agents, liability shall be limited to the amount of the damage foreseeable at the time of the conclusion of the contract, the occurrence of which must typically be expected. Otherwise, claims for damages are excluded.
10. dispute resolution
The European Commission provides a platform for online dispute resolution (ODR), which can be found here: https://ec.europa.eu/consumers/odr/. Consumers have the possibility to use this platform for the settlement of their disputes.
To settle disputes arising from a contractual relationship with a consumer or whether such a contractual relationship exists at all, we are obliged to participate in dispute resolution proceedings before a consumer arbitration board. The responsible body is the Universalschlichtungsstelle des Bundes am Zentrum für Schlichtung e.V., Straßburger Straße 8, 77694 Kehl am Rhein, www.verbraucher-schlichter.de. We will participate in a dispute resolution procedure before this body.
11. protection of minors
If your order includes goods whose sale is subject to age restrictions, we ensure that the customer has reached the required minimum age by using a reliable procedure involving a personal identity and age check. The delivery person will hand over the goods only after the age check has been carried out and only to the customer in person.
Delivery to packing stations is not possible in this case.