Excel 2002 Power Programming with VBA
This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.
Bonus: The book contains a coupon for the Professional Power Utility Pak.
Table of Contents
PART I: Some Essential Background.
Chapter 1: Excel 2002: Where It Came From.
Chapter 2: Excel in a Nutshell.
Chapter 3: Formula Tricks and Techniques.
Chapter 4: Understanding Excel's Files.
PART II: Excel Application Development.
Chapter 5: What is a Spreadsheet Application?
Chapter 6: Essentials of Spreadsheet Application Development.
PART III: Understanding Visual Basic for Applications.
Chapter 7: Introducing Visual Basic for Applications.
Chapter 8: VBA Programming Fundamentals.
Chapter 9: Working with VBA Sub Procedures.
Chapter 10: Creating Function Procedures.
Chapter 11: VBA Programming Examples and Techniques.
PART IV: Working with UserForms.
Chapter 12: Custom Dialog Box Alternatives.
Chapter 13: Introducing UserForms.
Chapter 14: UserForm Examples.
Chapter 15: Advanced UserForm Techniques.
PART V: Advanced Programming Techniques.
Chapter 16: Developing Excel Utilities with VBA.
Chapter 17: Working with Pivot Tables.
Chapter 18: Working with Charts.
Chapter 19: Understanding Excel's Events.
Chapter 20: Interacting with Other Applications.
Chapter 21: Creating and Using Add-Ins.
PART VI: Developing Applications.
Chapter 22: Creating Custom Toolbars.
Chapter 23: Creating Custom Menus.
Chapter 24: Providing Help for Your Applications.
Chapter 25: Developing User-Oriented Applications.
PART VII: Other Topics.
Chapter 26: Compatibility Issues.
Chapter 27: Manipulating Files with VBA.
Chapter 28: Manipulating Visual Basic Components.
Chapter 29: Understanding Class Modules.
Chapter 30: Frequently Asked Questions about Excel Programming.
Appendix A: Excel Resources Online.
Appendix B: VBA Statements and Functions Reference.
Appendix C: VBA Error Codes.
Appendix D: ANSI Code Reference.
Appendix E: What's on the CD-ROM.
End-User License Agreement.
CD-ROM Installation Instructions.
Sign up now »
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
- FTOS Web Applications DeveloperNSW
- FTFlash / ActionScript Developer - ContractNSW
- FTSenior Python DeveloperNSW
- FTR&D EngineerSA
- FTLead Software EngineerSA
- FTQuality ManagerSA
- FTTechnical Business AnalystNSW
The most comprehensive assessment of the current state of enterprise application quality and testing practices available from around the world. With our 1550 respondents, Capgemini, HP & Sogeti bring you ...
The nature of work has changed fundamentally and forever and it continues to evolve rapidly. Geographic distance and ...
"Suggesting that people's "purpose is to get information to flow through the ..."
Why change management doesn’t work
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
- Malware roundup: Tiffany's, Tibetans, iOs are targeted
- Schnucks wants federal court to handle data breach lawsuit
- Layered defenses largely fail to block exploits, says NSS
- Researchers warn of increased Zeus malware activity this year
- AusCERT 2013: Four dissenters to spur next year's security debates
- CITRIX SYNERGY ’13: Qureshi addresses the trend of ‘mojility’
- CITRIX SYNERGY ’13: IT needs to be empowered, says Sallam
- CITRIX SYNERGY ’13: Look beyond Cloud infrastructure, says Liang
- CITRIX SYNERGY ’13: Christiancen highlights the need for collaboration
- CITRIX SYNERGY ’13: Devices will change how people work, says Duursma
- Analytics and personalisation drive leading marketer behaviour: Report
- Innovation and big data take centre stage during CMO panel
- Twitter targets second screen interaction with Amplify advertising partnerships
- Facebook talks hyper-targeting, analytics and cross-platform at AANA event
- Tapping into social experience: Tourism Australia