內容簡介TOPTHIS GUIDE OUTLINES SCRIPTING TECHNIQUES AND SHOWS HOW TO USE MACROS WITH EXCEL 2010 VISUAL BASIC FOR APPLICATIONS (VBA) TO CREATE AUTOMATED REPORTS. COVERAGE PROGRESSES FROM VBA SYNTAX AND WORKING WITH RANGES AND CELLS, THROUGH USER-DEFINED FUNCTIONS, CREATING CHARTS, ADVANCED USEFORM TECHNIQUES, AND CREATING ADD-INS. STEP-BY-STEP INSTRUCTIONS ARE ILLUSTRATED B&W SCREENSHOTS, EXAMPLES, AND CASE STUDIES. A COMPANION WEB SITE OFFERS A SET OF 50 EXCEL WORKBOOKS THAT DEMONSTRATE CONCEPTS COVERED IN THE BOOK. THESE FILES INCLUDE ALL THE CODE FROM THE BOOK, SAMPLE DATA, NOTES FROM THE AUTHORS, AND 25 BONUS MACROS. JELEN HOSTS A WEB SITE ON EXCEL. SYRSTAD IS AN EXCEL CONSULTANT. ANNOTATION 穢2010 BOOK NEWS, INC., PORTLAND, OR (BOOKNEWS.COM)
留言列表