Writing Excel macros with VBA: [learning to program the Excel object model using VBA]
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip
O'Reilly
2002
|
| Edition: | 2. ed. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Item Description: | 1. Aufl. u.d.T.: Roman, Steven: Writing Excel macros |
| Physical Description: | XVIII, 549 S. graph. Darst. : 24 cm |
| ISBN: | 0596003595 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV014708909 | ||
| 003 | DE-604 | ||
| 007 | t | ||
| 008 | 020903s2002 gw d||| |||| 00||| eng d | ||
| 016 | 7 | |a 964976803 |2 DE-101 | |
| 020 | |a 0596003595 |c kart. : EUR 38.00, $ 34.95 |9 0-596-00359-5 | ||
| 035 | |a (OCoLC)248790559 | ||
| 035 | |a (DE-599)BVBBV014708909 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a gw |c DE | ||
| 049 | |a DE-355 |a DE-861 |a DE-11 | ||
| 082 | 0 | |a 005.369 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Roman, Steven |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Writing Excel macros with VBA |b [learning to program the Excel object model using VBA] |c Steven Roman. [Ed.: Ron Petrusha and Nancy Kotary] |
| 250 | |a 2. ed. | ||
| 264 | 1 | |a Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip |b O'Reilly |c 2002 | |
| 300 | |a XVIII, 549 S. |b graph. Darst. : 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a 1. Aufl. u.d.T.: Roman, Steven: Writing Excel macros | ||
| 650 | 4 | |a EXCEL 2000 - VisualBASIC für Applikationen | |
| 650 | 4 | |a EXCEL 2002 - VisualBASIC für Applikationen | |
| 650 | 0 | 7 | |a Excel 2002 |0 (DE-588)4640989-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Excel 2000 |0 (DE-588)4538839-8 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Excel 2000 |0 (DE-588)4538839-8 |D s |
| 689 | 0 | 1 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |D s |
| 689 | 1 | 1 | |a Excel 2002 |0 (DE-588)4640989-0 |D s |
| 689 | 1 | |5 DE-604 | |
| 856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009973890&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-009973890 | |
Record in the Search Index
| _version_ | 1808045499514617856 |
|---|---|
| adam_text |
TABLE
OF
CONTENTS
PREFACE
.
XI
1.
INTRODUCTION
.
1
SELECTING
SPECIAL
CELLS
1
SETTING
A
CHART
'
S
DATA
POINT
LABELS
3
TOPICS
IN
LEARNING
EXCEL
PROGRAMMING
4
PART
I.
THE
VBA
ENVIRONMENT
2.
PRELIMINARIES
.
9
WHAT
IS
A PROGRAMMING
LANGUAGE?
9
PROGRAMMING
STYLE
11
3.
THE
VISUAL
BASIC
EDITOR,
PART
I
.16
THE
PROJECT
WINDOW
16
THE
PROPERTIES
WINDOW
21
THE
CODE
WINDOW
21
THE
IMMEDIATE
WINDOW
25
ARRANGING
WINDOWS
26
4.
THE
VISUAL
BASIC
EDITOR,
PART
II
.
28
NAVIGATING
THE
IDE
28
GETTING
HELP
29
CREATING
A
PROCEDURE
30
RUN
TIME,
DESIGN
TIME,
AND
BREAK
MODE
31
ERRORS
32
DEBUGGING
36
MACROS
42
PART
II.
THE
VBA
PROGRAMMING
LANGUAGE
5.
VARIABLES,
DATA
TYPES,
AND
CONSTANTS
.
47
COMMENTS
47
LINE
CONTINUATION
47
CONSTANTS
48
VARIABLES
AND
DATA
TYPES
51
VBA
OPERATORS
68
6.
FUNCTIONS
AND
SUBROUTINES
.
69
CALLING
FUNCTIONS
69
CALLING
SUBROUTINES
70
PARAMETERS
AND
ARGUMENTS
71
EXITING
A
PROCEDURE
75
PUBLIC
AND
PRIVATE
PROCEDURES
76
PROJECT
REFERENCES
76
7.
BUILT-IN
FUNCTIONS
AND
STATEMENTS
.
78
THE
MSGBOX
FUNCTION
79
THE
INPUTBOX
FUNCTION
81
VBA
STRING
FUNCTIONS
82
MISCELLANEOUS
FUNCTIONS
AND
STATEMENTS
85
HANDLING
ERRORS
IN
CODE
88
8.
CONTROL
STATEMENTS
.93
THE
IF.THEN
STATEMENT
93
THE
FOR
LOOP
94
THE
FOR
EACH
LOOP
96
THE
DO
LOOP
96
THE
SELECT
CASE
STATEMENT
97
A
FINAL
NOTE
ON
VBA
98
VI
|
TABLE
OF
CONTENTS
PART
III.
EXCEL
APPLICATIONS
AND
THE
EXCEL
OBJECT
MODEL
9.
OBJECT
MODELS
.103
OBJECTS,
PROPERTIES,
AND
METHODS
103
COLLECTION
OBJECTS
104
OBJECT
MODEL
HIERARCHIES
107
OBJECT
MODEL
SYNTAX
107
OBJECT
VARIABLES
109
10.
EXCEL
APPLICATIONS
.
115
PROVIDING
ACCESS
TO
AN
APPLICATION
'
S
FEATURES
116
WHERE
TO
STORE
AN
APPLICATION
120
AN
EXAMPLE
ADD-IN
128
11.
EXCEL
EVENTS
.
132
THE
ENABLEEVENTS
PROPERTY
132
EVENTS
AND
THE
EXCEL
OBJECT
MODEL
133
ACCESSING
AN
EVENT
PROCEDURE
133
WORKSHEET
EVENTS
134
WORKBOOK
EVENTS
134
CHART
EVENTS
135
APPLICATION
EVENTS
136
QUERYTABLE
REFRESH
EVENTS
138
12.
CUSTOM
MENUS
AND
TOOLBARS
.
139
MENUS
AND
TOOLBARS:
AN
OVERVIEW
139
THE
COMMANDBARS
COLLECTION
142
CREATING
A
NEW
MENU
BAR
OR
TOOLBAR
143
COMMAND-BAR
CONTROLS
144
BUILT-IN
COMMAND-BAR-CONTROL
IDS
147
EXAMPLE:
CREATING
A
MENU
149
EXAMPLE:
CREATING
A
TOOLBAR
150
EXAMPLE:
ADDING
AN
ITEM
TO
AN
EXISTING
MENU
152
AUGMENTING
THE
SRXUTILS
APPLICATION
153
13.
BUILT-IN
DIALOG
BOXES
.
162
THE
SHOW
METHOD
165
TABLE
OF
CONTENTS
|
VIL
14.
CUSTOM
DIALOG
BOXES
.
167
WHAT
IS
A
USERFORM
OBJECT?
167
CREATING
A
USERFORM
OBJECT
168
ACTIVEX
CONTROLS
169
ADDING
USERFORM
CODE
169
EXCEL
'
S
STANDARD
CONTROLS
171
EXAMPLE:
THE
ACTIVATESHEET
UTILITY
173
ACTIVEX
CONTROLS
ON
WORKSHEETS
178
15.
THE
EXCEL
OBJECT
MODEL
.
183
A
PERSPECTIVE
ON
THE
EXCEL
OBJECT
MODEL
183
EXCEL
ENUMS
186
THE
VBA
OBJECT
BROWSER
189
16.
THE
APPLICATION
OBJECT
.
191
PROPERTIES
AND
METHODS
OF
THE
APPLICATION
OBJECT
194
CHILDREN
OF
THE
APPLICATION
OBJECT
219
17.
THE
WORKBOOK
OBJECT
.
224
THE
WORKBOOKS
COLLECTION
224
THE
WORKBOOK
OBJECT
230
CHILDREN
OF
THE
WORKBOOK
OBJECT
238
EXAMPLE:
SORTING
SHEETS
IN
A
WORKBOOK
241
18.
THE
WORKSHEET
OBJECT
.
243
PROPERTIES
AND
METHODS
OF
THE
WORKSHEET
OBJECT
243
CHILDREN
OF
THE
WORKSHEET
OBJECT
251
PROTECTION
IN
EXCEL
XP
255
EXAMPLE:
PRINTING
SHEETS
257
19.
THE
RANGE
OBJECT
.
263
THE
RANGE
OBJECT
AS
A
COLLECTION
265
DEFINING
A
RANGE
OBJECT
266
ADDITIONAL
MEMBERS
OF
THE
RANGE
OBJECT
272
CHILDREN
OF
THE
RANGE
OBJECT
303
EXAMPLE:
GETTING
THE
USED
RANGE
317
EXAMPLE:
SELECTING
SPECIAL
CELLS
319
VIII
|
TABLE
OF
CONTENTS
20.
PIVOTTABLES
.
332
PIVOT
TABLES
332
THE
PIVOTTABLE
WIZARD
335
THE
PIVOTTABLEWIZARD
METHOD
339
THE
PIVOTTABLE
OBJECT
341
PROPERTIES
AND
METHODS
OF
THE
PIVOTTABLE
OBJECT
347
CHILDREN
OF
THE
PIVOTTABLE
OBJECT
362
THE
PIVOTFIELD
OBJECT
362
THE
PIVOTCACHE
OBJECT
379
THE
PIVOTITEM
OBJECT
380
PIVOTCELL
AND
PIVOTLTEMLIST
OBJECTS
385
CALCULATED
ITEMS
AND
CALCULATED
FIELDS
389
EXAMPLE:
PRINTING
PIVOT
TABLES
391
21.
THE
CHART
OBJECT
.
397
CHART
OBJECTS
AND
CHARTOBJECT
OBJECTS
397
CREATING
A
CHART
399
CHART
TYPES
405
CHILDREN
OF
THE
CHART
OBJECT
409
THE
AXES
COLLECTION
410
THE
AXIS
OBJECT
413
THE
CHARTAREA
OBJECT
424
THE
CHARTGROUP
OBJECT
425
THE
CHARTTITLE
OBJECT
429
THE
DATATABLE
OBJECT
430
THE
FLOOR
OBJECT
430
THE
LEGEND
OBJECT
431
THE
PAGESETUP
OBJECT
433
THE
PLOTAREA
OBJECT
433
THE
SERIES
OBJECT
434
PROPERTIES
AND
METHODS
OF
THE
CHART
OBJECT
441
EXAMPLE:
SCROLLING
THROUGH
CHART
TYPES
446
EXAMPLE:
PRINTING
EMBEDDED
CHARTS
449
EXAMPLE:
SETTING
DATA
SERIES
LABELS
454
22.
SMART
TAGS
.
463
WHAT
ARE
SMART
TAGS?
463
SMARTTAGRECOGNIZER
OBJECT
464
TABLE
OF
CONTENTS
|
LX
SMARTTAG
OBJECT
465
SMARTTAGACTION
OBJECT
466
SMARTTAGOPTIONS
OBJECT
466
PART
IV.
APPENDIXES
A.
THE
SHAPE
OBJECT
.
471
B.
GETTING
THE
INSTALLED
PRINTERS
.
484
C.
COMMAND
BAR
CONTROLS
.
488
D.
FACE
IDS
.
499
E.
PROGRAMMING
EXCELFROM
ANOTHER
APPLICATION
.
505
F.
HIGH-LEVEL
AND
LOW-LEVEL
LANGUAGES
.
510
G.
NEW
OBJECTS
IN
EXCEL
XP
.
520
INDEX
.
535
X
|
TABLE
OF
CONTENTS |
| any_adam_object | 1 |
| author | Roman, Steven |
| author_facet | Roman, Steven |
| author_role | aut |
| author_sort | Roman, Steven |
| author_variant | s r sr |
| building | Verbundindex |
| bvnumber | BV014708909 |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)248790559 (DE-599)BVBBV014708909 |
| dewey-full | 005.369 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.369 |
| dewey-search | 005.369 |
| dewey-sort | 15.369 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 2. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV014708909</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">020903s2002 gw d||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">964976803</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596003595</subfield><subfield code="c">kart. : EUR 38.00, $ 34.95</subfield><subfield code="9">0-596-00359-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)248790559</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014708909</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">gw</subfield><subfield code="c">DE</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-355</subfield><subfield code="a">DE-861</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.369</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Roman, Steven</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Writing Excel macros with VBA</subfield><subfield code="b">[learning to program the Excel object model using VBA]</subfield><subfield code="c">Steven Roman. [Ed.: Ron Petrusha and Nancy Kotary]</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2002</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVIII, 549 S.</subfield><subfield code="b">graph. Darst. : 24 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">1. Aufl. u.d.T.: Roman, Steven: Writing Excel macros</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">EXCEL 2000 - VisualBASIC für Applikationen</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">EXCEL 2002 - VisualBASIC für Applikationen</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2002</subfield><subfield code="0">(DE-588)4640989-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">VisualBASIC für Applikationen</subfield><subfield code="0">(DE-588)4341325-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2000</subfield><subfield code="0">(DE-588)4538839-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Excel 2000</subfield><subfield code="0">(DE-588)4538839-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">VisualBASIC für Applikationen</subfield><subfield code="0">(DE-588)4341325-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">VisualBASIC für Applikationen</subfield><subfield code="0">(DE-588)4341325-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Excel 2002</subfield><subfield code="0">(DE-588)4640989-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009973890&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009973890</subfield></datafield></record></collection> |
| id | DE-604.BV014708909 |
| illustrated | Illustrated |
| indexdate | 2024-08-22T00:29:14Z |
| institution | BVB |
| isbn | 0596003595 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009973890 |
| oclc_num | 248790559 |
| open_access_boolean | |
| owner | DE-355 DE-BY-UBR DE-861 DE-11 |
| owner_facet | DE-355 DE-BY-UBR DE-861 DE-11 |
| physical | XVIII, 549 S. graph. Darst. : 24 cm |
| publishDate | 2002 |
| publishDateSearch | 2002 |
| publishDateSort | 2002 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Roman, Steven Verfasser aut Writing Excel macros with VBA [learning to program the Excel object model using VBA] Steven Roman. [Ed.: Ron Petrusha and Nancy Kotary] 2. ed. Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip O'Reilly 2002 XVIII, 549 S. graph. Darst. : 24 cm txt rdacontent n rdamedia nc rdacarrier 1. Aufl. u.d.T.: Roman, Steven: Writing Excel macros EXCEL 2000 - VisualBASIC für Applikationen EXCEL 2002 - VisualBASIC für Applikationen Excel 2002 (DE-588)4640989-0 gnd rswk-swf VisualBASIC für Applikationen (DE-588)4341325-0 gnd rswk-swf Excel 2000 (DE-588)4538839-8 gnd rswk-swf Excel 2000 (DE-588)4538839-8 s VisualBASIC für Applikationen (DE-588)4341325-0 s DE-604 Excel 2002 (DE-588)4640989-0 s DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009973890&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Roman, Steven Writing Excel macros with VBA [learning to program the Excel object model using VBA] EXCEL 2000 - VisualBASIC für Applikationen EXCEL 2002 - VisualBASIC für Applikationen Excel 2002 (DE-588)4640989-0 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd Excel 2000 (DE-588)4538839-8 gnd |
| subject_GND | (DE-588)4640989-0 (DE-588)4341325-0 (DE-588)4538839-8 |
| title | Writing Excel macros with VBA [learning to program the Excel object model using VBA] |
| title_auth | Writing Excel macros with VBA [learning to program the Excel object model using VBA] |
| title_exact_search | Writing Excel macros with VBA [learning to program the Excel object model using VBA] |
| title_full | Writing Excel macros with VBA [learning to program the Excel object model using VBA] Steven Roman. [Ed.: Ron Petrusha and Nancy Kotary] |
| title_fullStr | Writing Excel macros with VBA [learning to program the Excel object model using VBA] Steven Roman. [Ed.: Ron Petrusha and Nancy Kotary] |
| title_full_unstemmed | Writing Excel macros with VBA [learning to program the Excel object model using VBA] Steven Roman. [Ed.: Ron Petrusha and Nancy Kotary] |
| title_short | Writing Excel macros with VBA |
| title_sort | writing excel macros with vba learning to program the excel object model using vba |
| title_sub | [learning to program the Excel object model using VBA] |
| topic | EXCEL 2000 - VisualBASIC für Applikationen EXCEL 2002 - VisualBASIC für Applikationen Excel 2002 (DE-588)4640989-0 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd Excel 2000 (DE-588)4538839-8 gnd |
| topic_facet | EXCEL 2000 - VisualBASIC für Applikationen EXCEL 2002 - VisualBASIC für Applikationen Excel 2002 VisualBASIC für Applikationen Excel 2000 |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009973890&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT romansteven writingexcelmacroswithvbalearningtoprogramtheexcelobjectmodelusingvba |