Book Description
Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 100 tasks, including complete coverage of macros -- with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation.
Book Info
Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. Over 100 tasks are covered. Softcover. CD-ROM included.
From the Back Cover
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key VBA programming techniques for Excel macros, including:Working with the Visual Basic EditorUsing the Excel Object ModelUtilizing variables and arraysHarnessing built-in functionsDebugging macrosDefining rangesManipulating cellsCustomizing dialog boxesWorking with chartsAutomating proceduresExtra Apply It"Apply It" and "Extra" sidebars highlight useful tipsHigh-resolution screen shots demonstrate each taskSuccinct explanations walk you through step by stepTwo-page lessons break big topics into bite-sized modulesVBA development tools on CD-ROM!Code_Crafter 2000 and VBA code Print trial versionBarcode Add-in for Office demoVB Code Cutter sharewareAll sample code and spreadsheets from the bookSearchable e-version of the bookSystem requirements: PC running Windows 9x/2000/Me/XP, Windows NT 4 or later. See the "What's on the CD-ROM" Appendix for details and complete system requirements.
About the Author
About the Author Jinjer Simon has been actively involved in the computer industry for the past 17 years. Her involvement in the industry has included programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Windows CE For Dummies and Windows CE 2 For Dummies. Jinjer and her husband live in Coppell, Texas with their two children. She currently works as a consultant for MillenniSoft, Inc., providing Web site development and online documentation development.
Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets FROM THE PUBLISHER
Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 100 tasks, including complete coverage of macros -- with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation.
SYNOPSIS
This book/CD-ROM package uses simple examples to teach readers how to create Excel programs. It walks through the basics of using the Visual Basic Editor that comes with Microsoft Office, covers the Excel Object Model, and illustrates how to use the various objects, properties, and methods to create macros. Although the book requires no experience with programming, familiarity with the Windows operating system is helpful. The CD-ROM contains trial and demo software, sample code and spreadsheets from the book, and a searchable version of the book. Simon is the author of several computer books. The book shows Hungry Minds as the publisher, but that company is now part of Wiley. Annotation c. Book News, Inc., Portland, OR
FROM THE CRITICS
Booknews
This book/CD-ROM package uses simple examples to teach readers how to create Excel programs. It walks through the basics of using the Visual Basic Editor that comes with Microsoft Office, covers the Excel Object Model, and illustrates how to use the various objects, properties, and methods to create macros. Although the book requires no experience with programming, familiarity with the Windows operating system is helpful. The CD-ROM contains trial and demo software, sample code and spreadsheets from the book, and a searchable version of the book. Simon is the author of several computer books. The book shows Hungry Minds as the publisher, but that company is now part of Wiley. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Art & Photography
Book Info
