Buy Excel 2000 VBA Programmer's Reference at Bookstore UAE
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Business applications > Spreadsheet software > Excel 2000 VBA Programmer's Reference
Excel 2000 VBA Programmer's Reference

Excel 2000 VBA Programmer's Reference


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Excel 2000 is a part of the Office 2000 program suite, and is available in the Premium, Professional, Standard and Small Business editions of Office 2000. Excel has traditionally been the Office suite spreadsheet program par excellence. It still remains that way, but with Office 2000 there is a strong emphasis on between-application automation, ease of use, and the smart new bells and whistles that 2000 brings. Using VBA, the user can program his or her own programmes in what is a subset of the Visual Basic programming languages. This allows you to create great User Interfaces (forms etc), as a front end to actual spreadsheet and database storage and manipulation. This continues to be one of the great strengths of programming Excel VBA. This book presents a full reference to the Excel object model - which is essentially the object-oriented system of organizing the functional capacities that make up the Excel programme. There is a short introduction to VBA itself, and the rest of the book documents aspects of programming Excel through that object model. This book is divided into three broad sections: the first part introduces Excel and VBA; the second offers thematic discussions of some of the capacities available to Excel VBA. The third and final part offers a full reference to the object model of Excel.

Table of Contents:
Chapter 1: Introduction Chapter 2: Primer in Excel VBA Chapter 3: The Application Object Chapter 4: Workbooks and Worksheets Chapter 5: Using Ranges Chapter 6: Using Names Chapter 7: Filtered Lists Chapter 8: Generating Charts Chapter 9: Event Procedures Chapter 10: Adding Controls Chapter 11: UserForms Chapter 12: Command Bars Chapter 13: Class Modules Chapter 14: Addins Chapter 15: Interacting with other Office Applications Chapter 16: International Issues Chapter 17: Programming the VBE Chapter 18: Programming with the Windows API Appendix A: Excel 2000 Object Model Appendix B: VBE Object Model

About the Author :
Stephen Bullen lives in Milton Keynes, England with his wife and two dogs and is soon to become a father of twins. After graduating from Oxford University in 1992 with an MA in Engineering, Economics and Management, Stephen joined Price Waterhouse Management Consultants where he spent five years developing Excel applications for a wide range of multinational corporations. In 1997, Stephen started his own company, Business Modelling Solutions Ltd, specializing in Excel and Access development and consulting. The BMS web site, www.BMSLtd.co.uk, contains a large number of examples of his work, including tools and utilities to extend Excel's functionality and many examples of Excel development techniques. The entire site was recently awarded the accolade of 'VBA Power Tool of the Month' by Microsoft. Stephen enjoys helping other Excel users and devotes a lot of his spare time to answering questions in the CompuServe Excel forum and Microsoft's Internet newsgroups. In recognition of his contributions and knowledge, Microsoft has given him a 'Most Valuable Professional' award every year since 1996. Stephen can be contacted by email to Stephen@BMSLtd.co.uk, though any Excel support questions should be asked in the newsgroups. John Green lives and works in Sydney, Australia as an independent computer consultant, specializing in Excel and Access. With 30 years of computing experience, a Chemical Engineering degree and an MBA - he draws from a diverse background. He wrote his first programs in FORTRAN, took a part in the evolution of specialized planning languages on mainframes and, in the early 80's, became interested in spreadsheet systems including 1-2-3 and Excel. John established his company, Execuplan Consulting, in 1980, specializing in developing computer based planning applications and in training. He has led training courses extensively 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", published by Que. Since 1995 he has been accorded the status of MVP (Most Valuable Professional) by Microsoft for his contributions to the CompuServe Excel forum and MS Internet newsgroups. Email : jgreen@enternet.com.au Felipe Martins is an MCSD and MCT who has been programming with Office products and VB for many years, building applications in the manufacturing, healthcare, and aerospace industries. He currently works for ImagiNET Resources Corp. as a Senior Solutions Developer. ImagiNET Resources Corp supplies clients with leading edge business solutions by employing highly skilled and experienced people who are experts at using Microsoft technologies. Currently Felipe can be found somewhere in a Starbucks in Winnipeg, Canada. Felipe Martins can be reached at fmartins@imaginets.com


Best Sellers


Product Details
  • ISBN-13: 9781861002549
  • Publisher: WROX Press Ltd
  • Publisher Imprint: WROX Press Ltd
  • Height: 230 mm
  • Returnable: N
  • ISBN-10: 1861002548
  • Publisher Date: 19 May 2003
  • Binding: Paperback
  • Language: English
  • Weight: 980 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Excel 2000 VBA Programmer's Reference
WROX Press Ltd -
Excel 2000 VBA Programmer's Reference
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Excel 2000 VBA Programmer's Reference

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!