Ebooks
Micro$oft Office Excel 2007 Programming~tqw~ darksiderg
Torrent info
Torrent Files List
Torrent description
*******************************************************************************
Micro$oft Office Excel 2007 Programming
*******************************************************************************
-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 28,257,685 bytes
-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~
-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
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 Excel programming
techniques, including:
*Assigning digital signatures to macros
*Setting properties for a project
*Assigning values to a variable
*Changing the properties of an object
*Formatting a numeric expression
*Processing a runtime error
*Saving worksheets to another file
*Displaying a built-in dialog box
*Creating custom Ribbon tabs
*Building and debugging add-ins
Extra Apply It
*\"Apply It\" and \"Extra\" sidebars highlight useful tips
*High-resolution screen shots demonstrate each task
*Succinct explanations walk you through step by step
*Two-page lessons break big topics into bite-sized modules
Table of Contents
HOW TO USE THIS BOOK.
1 USING MACROS AND FORM CONTROLS.
2 USING THE VISUAL BASIC EDITOR.
3 INTRODUCING VISUAL BASIC FOR APPLICATIONS.
4 INTRODUCING THE EXCEL OBJECT MODEL.
5 UNDERSTANDING ARRAYS.
6 CONTROLLINGPROGRAM FLOW.
7 USING EXCEL WORKSHEET FUNCTIONS.
8 DEBUGGING MACROS.
9 WORKING WITH WORKBOOKS AND FILES.
10 WORKING WITH WORKSHEETS.
11 DEFINING RANGES.
12 WORKING WITH CELLS.
13 CREATING DIALOG BOXES AND CUSTOMIZING THE RIBBON.
14 WORKING WITH CHARTS.
15 AUTOMATING PROCEDURES WITH EXCEL EVENTS.
16 BUILDING ADD-INS.
17 UNDERSTANDING.
APPENDIX A: VBA QUICK REFERENCE.
APPENDIX B: RIBBON CONTROLS QUICK REFERENCE.
INDEX.
Product Details
* ISBN: 0470132302
* ISBN-13: 9780470132302
* Format: Other Format, 339pp
* Publisher: Wiley, John & Sons, Incorporated
* Pub. Date: September 2007
-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader