Excel VBA Macro Programming
(häftad)av Richard Shepherd
Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. Youll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.
(McGraw-Hill)
Fler böcker av Richard Shepherd
|
|
|
|
|||
Microsoft Access 2010 VBA Macro ProgrammingRichard Shepherd (häftad) |
Cardiff City Football ClubRichard Shepherd (häftad) |
Newport County Football ClubRichard Shepherd (häftad) |
Cardiff City Football Club, 1971-1993Richard Shepherd (häftad) | |||
|
236:- Köp
|
157:- Köp
|
133:- Köp
|
156:- Köp
|
Kundrecensioner
Bli först med att recensera och betygsätt boken Excel VBA Macro Programming -
du kan vinna 200 kr varje månad i tävlingen "Månadens recension".
Bloggat om Excel VBA Macro Programming
Övrig information
Richard Shepherd (Reading, Berkshire, England) is a qualified accountant with a special interest in computer languages, particularly Visual Basic, and he's spent the last 20 years developing computer software in blue chip organizations.
(McGraw-Hill)
Innehållsförteckning
Part I: Programming in Excel VBA
1: The Basics
2: Variables, Arrays, Constants, and Data Types
3: Modules, Functions, and Subroutines
4: Programming Basics: Decisions and Looping
5: Strings and Functions and Message Boxes
6: Operators
7: Debugging
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
2: Variables, Arrays, Constants, and Data Types
3: Modules, Functions, and Subroutines
4: Programming Basics: Decisions and Looping
5: Strings and Functions and Message Boxes
6: Operators
7: Debugging
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
4: Programming Basics: Decisions and Looping
5: Strings and Functions and Message Boxes
6: Operators
7: Debugging
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
6: Operators
7: Debugging
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
(McGraw-Hill)
