Writing Excel macros: [developing macros to automate and customize Excel ; covers Office 97 & 2000]
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | German |
| Veröffentlicht: |
Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip
O'Reilly
1999
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XIX, 529 S. graph. Darst. |
| ISBN: | 1565925874 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV012681419 | ||
| 003 | DE-604 | ||
| 005 | 20000131 | ||
| 007 | t | ||
| 008 | 990720s1999 gw d||| |||| 00||| ger d | ||
| 016 | 7 | |a 956751946 |2 DE-101 | |
| 020 | |a 1565925874 |9 1-56592-587-4 | ||
| 035 | |a (OCoLC)313656727 | ||
| 035 | |a (DE-599)BVBBV012681419 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a ger | |
| 044 | |a gw |c DE | ||
| 049 | |a DE-861 | ||
| 100 | 1 | |a Roman, Steven |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Writing Excel macros |b [developing macros to automate and customize Excel ; covers Office 97 & 2000] |c Steven Roman. [Ed.: Ron Petrusha] |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip |b O'Reilly |c 1999 | |
| 300 | |a XIX, 529 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a EXCEL 97 |0 (DE-588)4442558-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Excel 2000 |0 (DE-588)4538839-8 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a EXCEL 97 |0 (DE-588)4442558-2 |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 Excel 2000 |0 (DE-588)4538839-8 |D s |
| 689 | 1 | 1 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-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=008619193&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-008619193 | |
Datensatz im Suchindex
| _version_ | 1807504973884293120 |
|---|---|
| adam_text |
TABLE
OF
CONTENTS
PREFACE
.
XIII
1.
INTRODUCTION
.
1
SELECTING
SPECIAL
CELLS
.
1
SETTING
A
CHART
'
S
DATA
POINT
LABELS
.
3
TOPICS
IN
LEARNING
EXCEL
PROGRAMMING
.
5
2.
PRELIMINARIES
.
7
WHAT
IS
A
PROGRAMMING
LANGUAGE?
.
7
PROGRAMMING
STYLE
.
9
I.
THE
VBA
ENVIRONMENT
.
15
3
THE
VISUAL
BASIC
EDITOR,
PART
I
.
17
THE
PROJECT
WINDOW
.
17
THE
PROPERTIES
WINDOW
.
22
THE
CODE
WINDOW
.
23
THE
IMMEDIATE
WINDOW
.
26
ARRANGING
WINDOWS
.
27
4.
THE
VISUAL
BASIC
EDITOR,
PART
II
.
29
NAVIGATING
THE
IDE
.
29
GETTING
HELP
.
31
CREATING
A
PROCEDURE
.
31
RUN
TIME,
DESIGN
TIME,
AND
BREAK
MODE
.
32
ERRORS
.
33
VIA
TABLE
OF
CONTENTS
DEBUGGING
.
37
MACROS
.
43
IL
THE
VBA
PROGRAMMING
LANGUAGE
.
47
5.
VARIABLES,
DATA
TYPES,
AND
CONSTANTS
.
49
COMMENTS
.
49
LINE
CONTINUATION
.
49
CONSTANTS
.
50
VARIABLES
AND
DATA
TYPES
.
53
VBA
OPERATORS
.
70
6.
FUNCTIONS
AND
SUBROUTINES
.
71
CALLING
FUNCTIONS
.
71
CALLING
SUBROUTINES
.
73
PARAMETERS
AND
ARGUMENTS
.
73
EXITING
A
PROCEDURE
.
78
PUBLIC
AND
PRIVATE
PROCEDURES
.
78
PROJECT
REFERENCES
.
79
7.
BUILT-IN
FUNCTIONS
AND
STATEMENTS
.
81
THE
MSGBOX
FUNCTION
.
83
THE
INPUTBOX
FUNCTION
.
85
VBA
STRING
FUNCTIONS
.
86
MISCELLANEOUS
FUNCTIONS
AND
STATEMENTS
.
89
HANDLING
ERRORS
IN
CODE
.
92
8.
CONTROL
STATEMENTS
.
97
THE
IF.THEN
STATEMENT
.
97
THE
FOR
LOOP
.
98
THE
FOR
EACH
LOOP
.
100
THE
DO
LOOP
.
100
THE
SELECT
CASE
STATEMENT
.
101
A
FINAL
NOTE
ON
VBA
.
102
LIL.
EXCEL
APPLICATIONS
AND
THE
EXCEL
OBJECT
MODEL
.
105
9
OBJECT
MODELS
.
107
OBJECTS,
PROPERTIES,
AND
METHODS
.
107
COLLECTION
OBJECTS
.
109
TABLE
OF
CONTENTS
IX
OBJECT
MODEL
HIERARCHIES
.
ILL
OBJECT
MODEL
SYNTAX
.
112
OBJECT
VARIABLES
.
113
10.
EXCEL
APPLICATIONS
.
120
PROVIDING
ACCESS
TO
AN
APPLICATION
'
S
FEATURES
.
121
WHERE
TO
STORE
AN
APPLICATION
.
125
AN
EXAMPLE
ADD-IN
.
134
11.
EXCEL
EVENTS
.
138
THE
ENABLEEVENTS
PROPERTY
.
139
EVENTS
AND
THE
EXCEL
OBJECT
MODEL
.
139
ACCESSING
AN
EVENT
PROCEDURE
.
139
WORKSHEET
EVENTS
.
140
WORKBOOK
EVENTS
.
141
CHART
EVENTS
.
141
APPLICATION
EVENTS
.
142
QUERYTABLE
REFRESH
EVENTS
.
144
12.
CUSTOM
MENUS
AND
TOOLBARS
.
145
MENUS
AND
TOOLBARS:
AN
OVERVIEW
.
145
THE
COMMANDBARS
COLLECTION
.
148
CREATING
A
NEW
MENU
BAR
OR
TOOLBAR
.
150
COMMAND-BAR
CONTROLS
.
151
BUILT-IN
COMMAND-BAR-CONTROL
IDS
.
153
EXAMPLE:
CREATING
A
MENU
.
155
EXAMPLE:
CREATING
A
TOOLBAR
.
156
EXAMPLE:
ADDING
AN
ITEM
TO
AN
EXISTING
MENU
.
159
AUGMENTING
THE
SRXUTILS
APPLICATION
.
160
13
BUILT-IN
DIALOG
BOXES
.
169
THE
SHOW
METHOD
.
173
14.
CUSTOM
DIALOG
BOXES
.
175
WHAT
IS
A
USERFORM
OBJECT?
.
175
CREATING
A
USERFORM
OBJECT
.
176
ACTIVEX
CONTROLS
.
177
ADDING
USERFORM
CODE
.
178
EXCEL
'
S
STANDARD
CONTROLS
.
179
EXAMPLE:
THE
ACTIVATESHEET
UTILITY
.
181
ACTIVEX
CONTROLS
ON
WORKSHEETS
.
186
X
TABLE
OF
CONTENTS
15.
THE
EXCEL
OBJECT
MODEL
.
191
A
PERSPECTIVE
ON
THE
EXCEL
OBJECT
MODEL
.
191
EXCEL
ENUMS
.
195
THE
VBA
OBJECT
BROWSER
.
197
16.
THE
APPLICATION
OBJECT
.
199
PROPERTIES
AND
METHODS
OF
THE
APPLICATION
OBJECT
.
200
CHILDREN
OF
THE
APPLICATION
OBJECT
.
225
1
7.
THE
WORKBOOK
OBJECT
.
230
THE
WORKBOOKS
COLLECTION
.
230
THE
WORKBOOK
OBJECT
.
236
CHILDREN
OF
THE
WORKBOOK
OBJECT
.
244
EXAMPLE:
SORTING
SHEETS
IN
A
WORKBOOK
.
247
18.
THE
WORKSHEET
OBJECT
.
250
PROPERTIES
AND
METHODS
OF
THE
WORKSHEET
OBJECT
.
251
CHILDREN
OF
THE
WORKSHEET
OBJECT
.
258
EXAMPLE:
PRINTING
SHEETS
.
262
19
THE
RANGE
OBJECT
.
267
THE
RANGE
OBJECT
AS
A
COLLECTION
.
269
DEFINING
A
RANGE
OBJECT
.
270
ADDITIONAL
MEMBERS
OF
THE
RANGE
OBJECT
.
276
CHILDREN
OF
THE
RANGE
OBJECT
.
309
EXAMPLE:
GETTING
THE
USED
RANGE
.
323
EXAMPLE:
SELECTING
SPECIAL
CELLS
.
325
20.
PIVOT
TABLES
.
338
PIVOT
TABLES
.
338
THE
PIVOTTABLE
WIZARD
.
341
THE
PIVOTTABLEWIZARD
METHOD
.
344
THE
PIVOTTABLE
OBJECT
.
348
PROPERTIES
AND
METHODS
OF
THE
PIVOTTABLE
OBJECT
.
353
CHILDREN
OF
THE
PIVOTTABLE
OBJECT
.
369
THE
PIVOTFIELD
OBJECT
.
369
THE
PIVOTCACHE
OBJECT
.
386
THE
PIVOTITEM
OBJECT
.
387
CALCULATED
ITEMS
AND
CALCULATED
FIELDS
.
392
EXAMPLE:
PRINTING
PIVOT
TABLES
.
394
TABLE
OF
CONTENTS
XI
21.
THE
CHART
OBJECT
.
401
CHART
OBJECTS
AND
CHARTOBJECT
OBJECTS
.
402
CREATING
A
CHART
.
403
CHART
TYPES
.
410
CHILDREN
OF
THE
CHART
OBJECT
.
414
THE
AXES
COLLECTION
.
415
THE
AXIS
OBJECT
.
417
THE
CHARTAREA
OBJECT
.
429
THE
CHARTGROUP
OBJECT
.
430
THE
CHARTTITLE
OBJECT
.
434
THE
DATATABLE
OBJECT
.
435
THE
FLOOR
OBJECT
.
436
THE
LEGEND
OBJECT
.
436
THE
PAGESETUP
OBJECT
.
438
THE
PLOTAREA
OBJECT
.
439
THE
SERIES
OBJECT
.
439
PROPERTIES
AND
METHODS
OF
THE
CHART
OBJECT
.
447
EXAMPLE:
SCROLLING
THROUGH
CHART
TYPES
.
452
EXAMPLE:
PRINTING
EMBEDDED
CHARTS
.
455
EXAMPLE:
SETTING
DATA
SERIES
LABELS
.
460
IV
APPENDIXES
.
469
A.
THE
SHAPE
OBJECT
.
471
B.
GETTING
THE
INSTALLED
PRINTERS
.
482
C.
COMMAND
BAR
CONTROLS
.
486
D.
FACE
IDS
.
497
E.
PROGRAMMING
EXCEL
FROM
ANOTHER
APPLICATION
.
503
E
HIGH-LEVEL
AND
LOW-LEVEL
LANGUAGES
.
508
INDEX
.
519 |
| 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 | BV012681419 |
| ctrlnum | (OCoLC)313656727 (DE-599)BVBBV012681419 |
| edition | 1. 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">BV012681419</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20000131</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">990720s1999 gw d||| |||| 00||| ger d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">956751946</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1565925874</subfield><subfield code="9">1-56592-587-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)313656727</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV012681419</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">ger</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-861</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</subfield><subfield code="b">[developing macros to automate and customize Excel ; covers Office 97 & 2000]</subfield><subfield code="c">Steven Roman. [Ed.: Ron Petrusha]</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. 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">1999</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIX, 529 S.</subfield><subfield code="b">graph. Darst.</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="650" ind1="0" ind2="7"><subfield code="a">EXCEL 97</subfield><subfield code="0">(DE-588)4442558-2</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="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="689" ind1="0" ind2="0"><subfield code="a">EXCEL 97</subfield><subfield code="0">(DE-588)4442558-2</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">Excel 2000</subfield><subfield code="0">(DE-588)4538839-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" 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="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=008619193&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-008619193</subfield></datafield></record></collection> |
| id | DE-604.BV012681419 |
| illustrated | Illustrated |
| indexdate | 2024-08-16T01:17:48Z |
| institution | BVB |
| isbn | 1565925874 |
| language | German |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-008619193 |
| oclc_num | 313656727 |
| open_access_boolean | |
| owner | DE-861 |
| owner_facet | DE-861 |
| physical | XIX, 529 S. graph. Darst. |
| publishDate | 1999 |
| publishDateSearch | 1999 |
| publishDateSort | 1999 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Roman, Steven Verfasser aut Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] Steven Roman. [Ed.: Ron Petrusha] 1. ed. Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip O'Reilly 1999 XIX, 529 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier EXCEL 97 (DE-588)4442558-2 gnd rswk-swf Excel 2000 (DE-588)4538839-8 gnd rswk-swf VisualBASIC für Applikationen (DE-588)4341325-0 gnd rswk-swf EXCEL 97 (DE-588)4442558-2 s VisualBASIC für Applikationen (DE-588)4341325-0 s DE-604 Excel 2000 (DE-588)4538839-8 s DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=008619193&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Roman, Steven Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] EXCEL 97 (DE-588)4442558-2 gnd Excel 2000 (DE-588)4538839-8 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd |
| subject_GND | (DE-588)4442558-2 (DE-588)4538839-8 (DE-588)4341325-0 |
| title | Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] |
| title_auth | Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] |
| title_exact_search | Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] |
| title_full | Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] Steven Roman. [Ed.: Ron Petrusha] |
| title_fullStr | Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] Steven Roman. [Ed.: Ron Petrusha] |
| title_full_unstemmed | Writing Excel macros [developing macros to automate and customize Excel ; covers Office 97 & 2000] Steven Roman. [Ed.: Ron Petrusha] |
| title_short | Writing Excel macros |
| title_sort | writing excel macros developing macros to automate and customize excel covers office 97 2000 |
| title_sub | [developing macros to automate and customize Excel ; covers Office 97 & 2000] |
| topic | EXCEL 97 (DE-588)4442558-2 gnd Excel 2000 (DE-588)4538839-8 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd |
| topic_facet | EXCEL 97 Excel 2000 VisualBASIC für Applikationen |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=008619193&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT romansteven writingexcelmacrosdevelopingmacrostoautomateandcustomizeexcelcoversoffice972000 |