Excel 2000 VBA Programmer's Reference - Softcover

Green, John; Bullen, Stephen; Martins, Felipe

 
9781861002549: Excel 2000 VBA Programmer's Reference

Inhaltsangabe

Excel 2000 is an import part of the Office 2000 program suite, and will be 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 (Visual Basic for Applications), the user can program his or her own programs in what is essentially a subset of the Visual Basic programming languages. This is tremendously powerful, as it 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 program. There will be a short introduction to VBA itself, and the rest of the book will document aspects of programming Excel through that object model. This book will be in three broad sections: the first part introduces Excel and VBA; the second offers interesting, 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.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

Stephen Bullen
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 contains a large number of examples of his work, including tools and utilities to extend Excels 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 Microsofts 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
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 80s, 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
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

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Weitere beliebte Ausgaben desselben Titels

9780764544019: Excel 2000 VBA Programmers Reference

Vorgestellte Ausgabe

ISBN 10:  0764544012 ISBN 13:  9780764544019
Verlag: John Wiley &Sons, 1999
Softcover