Microsoft Excel is an enormously powerful and flexible application. Yet despite its powerful feature set, there is a great deal that Excel either does not allow you to do or does not allow you to do easily through its user interface. And in spite of Excel's reputation as the most widely used spreadsheet application, the majority of its users do not venture beyond the basics of creating spreadsheets and perhaps dabbling with macros. Consequently, these users aren't getting all the power out of this formidable application.With Writing Excel Macros you will learn there are many things you can do at the programming level that you cannot do at the user-interface level, that is, with the menus and dialog boxes of Excel. And learning how to get more power out of Excel will mean you can be more effective in your work.Writing Excel Macros offers a solid introduction to writing VBA macros and programs and provides Excel users and programmers unfamiliar with the Excel object model with an excellent overview to writing VBA macros and programs. The essentials of the VBA language and the Excel object model are covered so that, when you have finished the book, you will know enough about Excel VBA to begin creating effective working programs.In particular, the book focuses on:
Programming languages. Brief overview of programming and programming languages, as well as information on Variables, Data Types, and Constants, Functions and Subroutines, and more.
The Visual Basic Editor. Before tackling the basics of the programming language that Excel uses, the reader is acquainted with the VBA environment--the Visual Basic Editor.
Handling your code. An overview of where to store your code and how to activate it from an Excel spreadsheet.
The Excel object model. An in-depth overview of the Excel object model, including the Application, Workbook, Worksheet, and Range objects.
Appendices. Details on the Shape object; getting the Installed Printers; Command Bar Controls and Face IDs; programming Excel from another application; and more.
The information in this book is written in a succinct, practical manner that is characteristic of Steve Roman's straightforward approach. Readers will find useful examples throughout the book that deal with specific programming problems and allow them to gain hands-on experience in the VBA environment. Whether your interest in Excel programming is so you can be more effective in your work, or you want to learn how to write Excel programs for others to use, this book offers a solid introduction to writing VBA macros and programs and shows you how to get more power out of Excel at the programming level.
Essential COM (DevelopMentor Series) The Component Object Model (COM) is deep and extremely difficult, making it impossible to grasp the ideas behind this specification quickly or easily. Don Box, the author of Essential COM concedes that it took him six months of reading documentation, writing programs, and experiencing general puzzlement before he had his personal COM... Handbook of Nanophysics: Nanomedicine and Nanorobotics
The tools of nanodiagnostics, nanotherapy, and nanorobotics are expected to revolutionize the future of medicine, leading to presymptomatic diagnosis of disease, highly effective targeted treatment therapy, and minimum side effects. Handbook of Nanophysics: Nanomedicine and Nanorobotics presents an up-to-date overview of...
The Art of Sound Reproduction Designed to make life a little easier by providing all the theoretical background necessary to understand sound reproduction, backed up with practical examples. Specialist terms - both musical and physical - are defined as they occur and plain English is used throughout. Analog and digital audio are considered as alternatives, and the advantages of...
Microsoft Office 2003 All-in-One Learn to use the core Office applications, Web integration, and Windows XP quickly with ten manageable mini-books in one! Microsoft Office 2003 All-in-One is a step-by-step hands-on tutorial broken down into short, easily digestible lessons. It not only provides basic information on the Office applications, but also... Java 2: The Complete Reference, Third Edition
The definitive guide to Java!
Master Java, the pre-eminent language of the Internet, and begin reaping the benefits of this secure, platform-independent programming language. Let #1 programming author Herb Schildt show you everything you need to develop, compile, debug, and run Java applications and applets. Covering all of Java 2,...
WCDMA (UMTS) Deployment Handbook: Planning and Optimization Aspects A complete and practical guide to WCDMA/UMTS cellular network deployment.
After introducing the network architecture of such a system, the WCDMA (UMTS) Deployment Handbook defines the coverage and capacity concepts associated with the dimensioning and design phases. Progressing to a discussion of the main system parameters...