Excel-VBA: Einstieg für Anspruchsvolle
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | German |
| Veröffentlicht: |
München
Addison-Wesley
2008
|
| Schriftenreihe: | Master Class
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | 511 S. Ill. CD-ROM (12 cm) |
| ISBN: | 9783827325259 3827325250 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV023278118 | ||
| 003 | DE-604 | ||
| 005 | 20080728 | ||
| 007 | t| | ||
| 008 | 080425s2008 gw a||| |||| 00||| ger d | ||
| 015 | |a 07,N25,0058 |2 dnb | ||
| 016 | 7 | |a 984292675 |2 DE-101 | |
| 020 | |a 9783827325259 |c Pb. : EUR 29.95, EUR 30.80 (AT), sfr 51.50 |9 978-3-8273-2525-9 | ||
| 020 | |a 3827325250 |c Pb. : EUR 29.95, EUR 30.80 (AT), sfr 51.50 |9 3-8273-2525-0 | ||
| 024 | 3 | |a 9783827325259 | |
| 035 | |a (OCoLC)227006126 | ||
| 035 | |a (DE-599)DNB984292675 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a ger | |
| 044 | |a gw |c XA-DE-BY | ||
| 049 | |a DE-91G |a DE-92 |a DE-859 |a DE-Aug4 |a DE-12 |a DE-29T |a DE-11 |a DE-384 |a DE-19 | ||
| 082 | 0 | |a 005.54 |2 22/ger | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 084 | |a DAT 357f |2 stub | ||
| 084 | |a DAT 304f |2 stub | ||
| 100 | 1 | |a Schwimmer, Michael |d 1960- |e Verfasser |0 (DE-588)129605670 |4 aut | |
| 245 | 1 | 0 | |a Excel-VBA |b Einstieg für Anspruchsvolle |c Michael Schwimmer |
| 264 | 1 | |a München |b Addison-Wesley |c 2008 | |
| 300 | |a 511 S. |b Ill. |e CD-ROM (12 cm) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Master Class | |
| 650 | 0 | 7 | |a Excel 2007 |0 (DE-588)7558101-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |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 2007 |0 (DE-588)7558101-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 |0 (DE-588)4138932-3 |D s |
| 689 | 1 | 1 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |D s |
| 689 | 1 | |8 1\p |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=016462965&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-016462965 | |
Datensatz im Suchindex
| _version_ | 1826212266159112192 |
|---|---|
| adam_text |
INHALTSVERZEICHNIS
VORWORT 11
KAPITEL
1
GRUNDLAGEN 15
1.1 WAS SIE IN DIESEM KAPITEL ERWARTET 15
1.2 KOMMENTARE 15
1.3 GESCHWINDIGKEIT VON VBA 16
1.4 VARIABLEN 17
1.4.1 VARIABLENNAMEN 17
1.4.2 NAMENSKONVENTIONEN 20
1.4.3 DATENTYPEN 22
1.4.4 VARIABLENDEKLARATION 26
1.4.5 DEFTYPE 31
1.4.6 GUELTIGKEITSBEREICH 33
1.4.7 LEBENSDAUER 35
1.5 KONSTANTEN 36
1.5.1 NORMALE KONSTANTEN 36
1.5.2 ENUM-TYPEN 36
1.6 DOEVENTS 37
1.7 BENUTZERDEFINIERTE TABELLENFUNKTIONEN 40
1.8 PARAMETERUEBERGABE BYVAL VERSUS BYREF 40
1.9 PERFORMANCE STEIGERN 42
1.9.1 SELECT CASE VERSUS IF THEN 42
1.9.2 LOGISCHE OPERATOREN 47
1.9.3 REFERENZIERUNG UND OBJEKTVARIABLEN 51
1.9.4 BILDSCHIRMAKTUALISIERUNGEN 54
1.9.5 BERECHNUNGEN AUSSCHALTEN 56
1.9.6 WEITERE OPTIMIERUNGSMOEGLICHKEITEN 57
1.10 REKURSIONEN 62
1.11 SORTIEREN UND MISCHEN 64
1.11.1
BUBBLESORT 66
1.11.2
QUICKSORT 67
1.11.3
MISCHEN 70
1.12 FARBEN 71
1.12.1
AUSWAHL EINER RGB-FARBE 74
1.12.2
EINZELFARBEN AUS EINER RGB-FARBE EXTRAHIEREN 76
GESCANNT DURCH
BIBLIOGRAFISCHE INFORMATIONEN
HTTP://D-NB.INFO/984292675
DIGITALISIERT DURCH |
| adam_txt | |
| any_adam_object | 1 |
| any_adam_object_boolean | |
| author | Schwimmer, Michael 1960- |
| author_GND | (DE-588)129605670 |
| author_facet | Schwimmer, Michael 1960- |
| author_role | aut |
| author_sort | Schwimmer, Michael 1960- |
| author_variant | m s ms |
| building | Verbundindex |
| bvnumber | BV023278118 |
| classification_rvk | ST 371 |
| classification_tum | DAT 357f DAT 304f |
| ctrlnum | (OCoLC)227006126 (DE-599)DNB984292675 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| 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">BV023278118</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20080728</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">080425s2008 gw a||| |||| 00||| ger d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">07,N25,0058</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">984292675</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9783827325259</subfield><subfield code="c">Pb. : EUR 29.95, EUR 30.80 (AT), sfr 51.50</subfield><subfield code="9">978-3-8273-2525-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">3827325250</subfield><subfield code="c">Pb. : EUR 29.95, EUR 30.80 (AT), sfr 51.50</subfield><subfield code="9">3-8273-2525-0</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9783827325259</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)227006126</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)DNB984292675</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">XA-DE-BY</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-859</subfield><subfield code="a">DE-Aug4</subfield><subfield code="a">DE-12</subfield><subfield code="a">DE-29T</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-384</subfield><subfield code="a">DE-19</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">22/ger</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="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 357f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 304f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Schwimmer, Michael</subfield><subfield code="d">1960-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)129605670</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel-VBA</subfield><subfield code="b">Einstieg für Anspruchsvolle</subfield><subfield code="c">Michael Schwimmer</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">München</subfield><subfield code="b">Addison-Wesley</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">511 S.</subfield><subfield code="b">Ill.</subfield><subfield code="e">CD-ROM (12 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="490" ind1="0" ind2=" "><subfield code="a">Master Class</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2007</subfield><subfield code="0">(DE-588)7558101-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</subfield><subfield code="0">(DE-588)4138932-3</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 2007</subfield><subfield code="0">(DE-588)7558101-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</subfield><subfield code="0">(DE-588)4138932-3</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="8">1\p</subfield><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=016462965&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016462965</subfield></datafield></record></collection> |
| id | DE-604.BV023278118 |
| illustrated | Illustrated |
| index_date | 2024-07-02T20:38:37Z |
| indexdate | 2025-03-10T13:02:13Z |
| institution | BVB |
| isbn | 9783827325259 3827325250 |
| language | German |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016462965 |
| oclc_num | 227006126 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM DE-92 DE-859 DE-Aug4 DE-12 DE-29T DE-11 DE-384 DE-19 DE-BY-UBM |
| owner_facet | DE-91G DE-BY-TUM DE-92 DE-859 DE-Aug4 DE-12 DE-29T DE-11 DE-384 DE-19 DE-BY-UBM |
| physical | 511 S. Ill. CD-ROM (12 cm) |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Addison-Wesley |
| record_format | marc |
| series2 | Master Class |
| spelling | Schwimmer, Michael 1960- Verfasser (DE-588)129605670 aut Excel-VBA Einstieg für Anspruchsvolle Michael Schwimmer München Addison-Wesley 2008 511 S. Ill. CD-ROM (12 cm) txt rdacontent n rdamedia nc rdacarrier Master Class Excel 2007 (DE-588)7558101-2 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf VisualBASIC für Applikationen (DE-588)4341325-0 gnd rswk-swf Excel 2007 (DE-588)7558101-2 s VisualBASIC für Applikationen (DE-588)4341325-0 s DE-604 EXCEL (DE-588)4138932-3 s 1\p DE-604 DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016462965&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Schwimmer, Michael 1960- Excel-VBA Einstieg für Anspruchsvolle Excel 2007 (DE-588)7558101-2 gnd EXCEL (DE-588)4138932-3 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd |
| subject_GND | (DE-588)7558101-2 (DE-588)4138932-3 (DE-588)4341325-0 |
| title | Excel-VBA Einstieg für Anspruchsvolle |
| title_auth | Excel-VBA Einstieg für Anspruchsvolle |
| title_exact_search | Excel-VBA Einstieg für Anspruchsvolle |
| title_exact_search_txtP | Excel-VBA Einstieg für Anspruchsvolle |
| title_full | Excel-VBA Einstieg für Anspruchsvolle Michael Schwimmer |
| title_fullStr | Excel-VBA Einstieg für Anspruchsvolle Michael Schwimmer |
| title_full_unstemmed | Excel-VBA Einstieg für Anspruchsvolle Michael Schwimmer |
| title_short | Excel-VBA |
| title_sort | excel vba einstieg fur anspruchsvolle |
| title_sub | Einstieg für Anspruchsvolle |
| topic | Excel 2007 (DE-588)7558101-2 gnd EXCEL (DE-588)4138932-3 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd |
| topic_facet | Excel 2007 EXCEL VisualBASIC für Applikationen |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016462965&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT schwimmermichael excelvbaeinstiegfuranspruchsvolle |