Warriors B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | May 19, 2015

    Christopher Robinson and Gavin Kovite: IMG Nine Funny Animal Videos That Will Help You Write Your Novel!



    If you thought watching funny animal videos was a bad habit, a time-sink, a distraction from writing your novel, well, you're probably right. But if... Continue »
    1. $18.20 Sale Hardcover add to wish list

      War of the Encyclopaedists

      Christopher Robinson and Gavin Kovite 9781476775425

    spacer

Excel 2000 VBA Programmer's Reference (Programmer's Reference)

Excel 2000 VBA Programmer's Reference (Programmer's Reference) Cover

 

Synopses & Reviews

Publisher Comments:

What is this book about?

Excel 2000 is an important 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.

What does this book cover?

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 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 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.

Who is this book for?

This book is for the Excel developer or user who already has a knowledge of spreadsheets, and the basic objects of an Excel spreadsheet, and now wants a solid and detailed reference to the main object models present in the Excel structure with examples of how to use these models.

Book News Annotation:

This programmer's guide describes the Excel 2000 object model and the Excel VBE object model, introduces VBA programming, and offers instructions on automating tasks, customizing command bars, integrating add-ins, and using API call. The authors are programmers and consultants.
Annotation 2004 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

VBA allows you to take complete control of Excel and to automate all your Excel worksheet activities. With VBA you can customize everything you do in Excel 2000, so you can work faster and more efficiently. Learn how to take your worksheets and charts to the next level, employing Userforms, custom controls and filtered lists. This book provides you with the complete reference to the Excel VBA language, plus countless hints, tips and workarounds from Excel experts.

Who is this book for?

This book is for anyone who wants to take full advantage of the VBA programming language that comes with Excel 2000. If you’re new to VBA programming, this book will give you enough information to start making Excel work for you.

This book is also intended for power users who want to take advantage of the advanced features of Excel VBA and who needed a fast reference to the full Excel object model.

What does this book cover?

  • The complete Excel 2000 object model
  • The Excel VBE object model
  • An introduction to VBA programming
  • Automating your Excel tasks
  • Creating custom command bars
  • How to integrate Excel Add-Ins
  • Using API call from within Excel

The Wrox Philosophy

Our aim is to make you successful by sharing with you the knowledge of experienced programmers at every stage in your career.

As an experienced developer, you need to get the facts on a new technology fast. Without the marketing hype, without the trivial introduction. That’s what Wrox Programmer’s References deliver. Hard facts on the newest technologies with practical examples of how to apply new tools to your development projects today.

Synopsis:

What is this book about?

Excel 2000 is an important 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.

What does this book cover?

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 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 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.

Who is this book for?

This book is for the Excel developer or user who already has a knowledge of spreadsheets, and the basic objects of an Excel spreadsheet, and now wants a solid and detailed reference to the mainobject models present in the Excel structure with examples of how to use these models.

About the Author

John Green lives in Australia and runs his own company, Execuplan Consulting. He has written for various computing publications and was a contributing editor on Australian PC World Magazine. He also has a history of running seminars and creating Excel training ideos.

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.

Product Details

ISBN:
9780764544019
Publisher:
Wrox Press
Location:
Indianapolis, IN
Author:
Bullen, Stephen
Author:
Johnson, Brian
Author:
Martins, Felipe
Author:
Green, John
Subject:
Business
Subject:
Programming - General
Subject:
Programming Languages - Visual BASIC
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Microsoft Excel
Subject:
Microsoft Visual Basic for Windows
Subject:
Programming - Software Development
Subject:
Computer Languages-Visual Basic
Copyright:
Series:
Programmer's Reference
Series Volume:
16
Publication Date:
June 1999
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
744
Dimensions:
9.23x6.17x1.59 in. 2.27 lbs.

Related Subjects

Business » Personal Finance
Computers and Internet » Computer Languages » Visual Basic
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Software Engineering » Programming and Languages

Excel 2000 VBA Programmer's Reference (Programmer's Reference)
0 stars - 0 reviews
$ In Stock
Product details 744 pages Wrox Press - English 9780764544019 Reviews:
"Synopsis" by , VBA allows you to take complete control of Excel and to automate all your Excel worksheet activities. With VBA you can customize everything you do in Excel 2000, so you can work faster and more efficiently. Learn how to take your worksheets and charts to the next level, employing Userforms, custom controls and filtered lists. This book provides you with the complete reference to the Excel VBA language, plus countless hints, tips and workarounds from Excel experts.

Who is this book for?

This book is for anyone who wants to take full advantage of the VBA programming language that comes with Excel 2000. If you’re new to VBA programming, this book will give you enough information to start making Excel work for you.

This book is also intended for power users who want to take advantage of the advanced features of Excel VBA and who needed a fast reference to the full Excel object model.

What does this book cover?

  • The complete Excel 2000 object model
  • The Excel VBE object model
  • An introduction to VBA programming
  • Automating your Excel tasks
  • Creating custom command bars
  • How to integrate Excel Add-Ins
  • Using API call from within Excel

The Wrox Philosophy

Our aim is to make you successful by sharing with you the knowledge of experienced programmers at every stage in your career.

As an experienced developer, you need to get the facts on a new technology fast. Without the marketing hype, without the trivial introduction. That’s what Wrox Programmer’s References deliver. Hard facts on the newest technologies with practical examples of how to apply new tools to your development projects today.

"Synopsis" by , What is this book about?

Excel 2000 is an important 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.

What does this book cover?

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 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 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.

Who is this book for?

This book is for the Excel developer or user who already has a knowledge of spreadsheets, and the basic objects of an Excel spreadsheet, and now wants a solid and detailed reference to the mainobject models present in the Excel structure with examples of how to use these models.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.