BackCover

 < Day Day Up > 



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

About the Authors

Curtis Frye is the author of Microsoft Office Excel Step by Step, Microsoft Excel Version 2002 Plain & Simple, Faster Smart Home Networking, several books on Microsoft Access, and numerous online training courses.

Wayne S. Freeze, a computer consultant and an author with more than a dozen books and 50+ articles to his credit, specializes in programming for Microsoft Office, Microsoft SQL Server, and Microsoft DirectX.

Felicia K. Buckingham, an expert on Excel and VBA programming, is the principal of FKB Consulting, based in Manitoba, Canada.



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net