Excel Programming

Excel Programming

-

English
368 Pages

Description

A great guide to Excel programming that is perfect for visuallearners and takes you beyond Excel basics!

This book is the perfect reference for Excel users who want todelve deeper into the application to create powerful and dynamicprograms. From creating macros to customizing dialog boxes, thisstep-by-step guide helps you get more out of Excel than you knewwas possible. Each step has callouts so you can see exactly wherethe action takes place and this Web site offers tons of usable codeand sample macros that you can put to use instantly.

  • Explains step-by-step how to automate Excel, the world'sleading spreadsheet application from Microsoft
  • Covers most tasks in two-page spreads -- no flipping back andforth required!
  • Teaches you over 130 tasks, including how to record macros,program in Visual Basic for Applications (VBA), debug code,automate charts, interface with other macros, automate functions --all in an easy-to-follow visual format
  • Uses clear, step-by-step, numbered instruction and lots ofgraphics and screenshots -- perfect for visual learners!
  • Helps you maximize your productivity with practical examples,tips, and advice

 Harness everything that Excel has to offer with thisfriendly, practical, visual guide.

Subjects

Informations

Published by
Published 13 January 2011
Reads 1
EAN13 9781118036297
License: All rights reserved
Language English

Legal information: rental price per page €. This information is given for information only in accordance with current legislation.

Report a problem
HOW TO USE THIS BOOK V
1 USING MACROS AND FORM CONTROLS 2
Introducing Excel Programming 2
Introducing Macros 4
Set Macro Security 6
Create a Digital Signature 7
Record a Macro 8
Assign a Digital Signature to a Macro 10
Run a Macro 12
Create and Launch a Keyboard Shortcut 14
Assign a Macro to the Quick Access Toolbar 16
Delete a Macro 18
Add a Form Control to a Worksheet 20
Assign Values to a Form Control 22
Add a Macro to a Form Control 24
2 USING THE VISUAL BASIC EDITOR 26
Introducing the Visual Basic Editor 26
Activate the Visual Basic Editor 28
Open Visual Basic Editor Windows 30
Set Properties for a Project 32
Set Display Options for the Code Window 34
Add a New Module 36
Remove a Module 38
Hide a Macro 40
Update a Macro 42
3 INTRODUCING VISUAL BASIC FOR APPLICATIONS 44
Create Sub Procedures 44
Create Functions 46
Comment Your Code 48
Reference Cells and Ranges 50
Understanding Variables and Data Types 52
Declare Variables 54
Work with Strings 56
Work with Numbers 58
Create a Constant 60
4 INTRODUCING THE EXCEL OBJECT MODEL 62
Discover the Excel Object Model 62
Access the Excel Object Model Reference 64
Create an Object Variable 66
Change the Properties of an Object 68
Compare Object Variables 70
Using an Object Method 72
Display a Built-in Dialog Box 74
5 UNDERSTANDING ARRAYS 76
Declare an Array 76
Declare a Multidimensional Array 78
Convert a List to an Array 80
Redimension an Array 82
Create a User-Defined Data Type 84
6 CONTROLLING PROGRAM FLOW 86
Create Comparisons 86
Make Use of Logical Operators 87
Employ Do While Loops 88
Create Do Until Loops 90
Create For Next Loops 92
Execute For Each In Loops 94
Create If Then Else Statements 96
Construct Select Case Statements 98
GoTo a Named Location 100
Call a Procedure 102
7 USING EXCEL WORKSHEET FUNCTIONS 104
Work with Excel Worksheet Functions 104
Work with a MsgBox Function 106
Using the InputBox Function 108
Retrieve the Current Date and Time 110
Perform Date and Time Calculations 112
Format a Date Expression 114
Format a Numeric Expression 116
Change the Case of a String 118
Return a Portion of a String 120
8 DEBUGGING MACROS 122
Debug a Procedure with Inserted Breakpoints 122
Using the Watches Window to Debug a Procedure 124
Step through a Procedure 126
Using the Immediate Window 128
Resume Execution When an Error Is Encountered 130
Process a Runtime Error 132
9 WORKING WITH WORKBOOKS AND FILES 134
Open a Workbook 134
Open a Text File as a Workbook 136
Open a File Requested by the User 138
Save a Workbook 140
Save a Workbook in a Format Specified by the User 142
Determine if a Workbook Is Open 144
Close a Workbook 146
Create a New Workbook 148
Delete a File 150
10 WORKING WITH WORKSHEETS 152
Add a Sheet 152
Delete a Sheet 154