| You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format. Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!
- From automating simple tasks to creating custom solutions, write better code with VBA
- Learn best practices for writing and debugging your own macros
- Use VBA code to manage dates and times, reformat worksheets, and locate external files
- Extend your Excel-based solutions by developing your own add-ins
- Get powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic views
- Create custom command bars, dialog boxes, and user forms
- Employ ActiveX Data Objects (ADO) to access external databases
- Exploit the new XML capabilities in Excel 2003
|
|
|
Software Development Rhythms: Harmonizing Agile Practices for SynergyIn the deep dark night, lying down on Kande beach on the shores of Lake Malawi, we looked up into the cloudless sky. Countless tiny stars were blinking at us. A little tired, or perhaps just mesmerized by those distant, mysterious lights, we closed our eyes and began to hear more, the peaceful slap of water on the little beach, and the small,... | | Electro-Optics Handbook
It’s often difficult to predict which areas of a field will become rejuvenated and grow rapidly or spin off to fit with another to form something new. The field of electro-optics is also unpredictable, but currently it has numerous forces acting on it. First is the development of new optical sources such as ultrafast lasers and fiber... | | Visual Studio 2010 and .NET 4 Six-in-One (Wrox Programmer to Programmer)
Complete coverage of all key .NET 4 and Visual Studio 2010 languages and technologies
.NET 4 is Microsoft's latest version of their core programming platform, and Visual Studio 2010 is the toolset that helps write .NET 4 applications. This comprehensive resource offers one-stop shopping for all you need to know to get... |
|