Excel 2007 VBA: programmer's reference
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Indianapolis, Ind.
Wrox, Wiley
2007
|
| Series: | Programmer to programmer
Wrox programmer's references |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis Inhaltsverzeichnis |
| Physical Description: | XXX, 1143 S. Ill., graph. Darst. 24 cm |
| ISBN: | 0470046430 9780470046432 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV036069571 | ||
| 003 | DE-604 | ||
| 005 | 20130813 | ||
| 007 | t | ||
| 008 | 100309s2007 ad|| |||| 00||| eng d | ||
| 020 | |a 0470046430 |c (pbk) : £25.99 |9 0-470-04643-0 | ||
| 020 | |a 9780470046432 |c (pbk) : £25.99 |9 978-0-470-04643-2 | ||
| 035 | |a (OCoLC)255270597 | ||
| 035 | |a (DE-599)GBV518658309 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-862 | ||
| 050 | 0 | |a HF5548.4.M523 | |
| 082 | 0 | |a 005.54 |2 22 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Green, John |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Excel 2007 VBA |b programmer's reference |c John Green .... |
| 246 | 1 | 3 | |a Excel 2007 VBA programmer's reference |
| 264 | 1 | |a Indianapolis, Ind. |b Wrox, Wiley |c 2007 | |
| 300 | |a XXX, 1143 S. |b Ill., graph. Darst. |c 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Programmer to programmer | |
| 490 | 0 | |a Wrox programmer's references | |
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Microsoft Excel (Computer file) | |
| 650 | 0 | |a Business / Computer programs | |
| 650 | 4 | |a Wirtschaft | |
| 650 | 4 | |a Business |x Computer programs | |
| 650 | 0 | 7 | |a VisualBASIC für Applikationen |0 (DE-588)4341325-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Excel 2007 |0 (DE-588)7558101-2 |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 | |
| 856 | 4 | |m DE-605 |q pdf/application |u http://www.gbv.de/dms/hbz/toc/ht015320208.pdf |x 2008-11-15 |3 Inhaltsverzeichnis | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018960875&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-018960875 | ||
Record in the Search Index
| DE-BY-862_location | 2350 |
|---|---|
| DE-BY-FWS_call_number | 2350/ST 371 E91 G796 |
| DE-BY-FWS_katkey | 489979 |
| DE-BY-FWS_media_number | 083000508170 |
| _version_ | 1824553886362370048 |
| adam_text | Contents
Acknowledgments xxi
Introduction xxiii
Chapter 1: Primer in Excel VBA 1.
Using the Macro Recorder 2
Recording Macros 2
Running Macros 6
The Visual Basic Editor 8
Other Ways to Run Macros H
User-Defined Functions 17
Creating a UDF 18
What UDFs Cannot Do 21
The Excel Object Model 21
Objects 22
Getting Help 27
Experimenting in the Immediate Window 29
The VBA Language 30
Basic Input and Output 30
Calling Functions and Sub Procedures 35
Parentheses and Argument Lists 37
Variable Declaration 38
Scope and Lifetime of Variables 40
Variable Type 42
Object Variables 45
Making Decisions 47
Looping 50
Arrays 55
Run-Time Error-Handling 59
Summary 62
Charter 2: The Application Object 6^
Globais 63
The Active Properties M
Display Alerts 65
Screen Updatlng 66
Contents
Evaluate 66
InputBox 68
StatusBar 7q
SendKeys 70
OnTime 71
OnKey 72
Worksheet Functions 73
Caller 74
Summary 75
£haBter_3: Workbooks and Worksheets 2X
The Workbooks Collection 77
Getting a Filename from a Path 78
Files in the Same Directory 81
Overwriting an Existing Workbook 81
Saving Changes 82
The Sheets Collection 83
Worksheets 83
Copy and Move 85
Grouping Worksheets 87
The Window Object 89
Synchronizing Worksheets 90
Summary 91
£haBter_4: Using Ranges 93^
Activate and Select 93
Range Property 95
Shortcut Range References 96
Ranges on Inactive Worksheets 96
Range Property of a Range Object 97
Cells Property g7
Cells Used in Range 98
Ranges of Inactive Worksheets 99
More on the Cells Property of the Range Object 99
Single-Parameter Range Reference 101
Offset Property 102
Resize Property 103
SpeciaICells Method 105
Last Cell 105
Deleting Numbers 107
Contents
CurrentRegion Property 108
End Property 110
Referring to Ranges with End 110
Summing a Range 111
Columns and Rows Properties 112
Areas 113
Union and Intersect Methods 115
Empty Cells 115
Transferring Values between Arrays and Ranges 118
Deleting Rows 121
Summary 123
Chapter 5: Using Names 125
Naming Ranges 127
Using the Name Property of the Range Object 128
Special Names 128
Storing Values in Names 129
Storing Arrays 130
Hiding Names 131
Working with Named Ranges 132
Searching for a Name 133
Searching for the Name of a Range 135
Determining which Names Overlap a Range 136
Summary 139
Chapter 6: Data Lists 14i
Structuring the Data 141
Sorting a Range 142
Older Excel Versions 144
Creating a Table 144
Sorting a Table 145
AutoFilter 146
AutoFilter Object 147
Filter Object 148
Date Custom Filter 148
Adding Combo Boxes 149
Copying the Visible Rows 153
Finding the Visible Rows 154
Advanced Filter 156
Data Form 158
Summary 159
Contents
Chapter 7: PivotTables lß^
Creating a PivotTable Report 162
PivotCaches 165
PivotTables Collection 165
PivotFields 166
CalculatedFields 170
Pivotltems 171
Grouping 171
Visible Property 175
Calculatedltems 176
PivotCharts 177
External Data Sources 178
Summary ^gO
Chapter 8: Chart« Igi
Chart Sheets 182
The Recorded Macro 184
Adding a Chart Sheet Using VBA Code 184
Embedded Charts !85
Using the Macro Recorder 186
Adding an Embedded Chart Using VBA Code 186
Editing Data Series ^87
Defining Chart Series with Arrays 190
Converting a Chart to Use Arrays 193
Determining the Ranges Used in a Chart 194
Chart Labels 195
Summary ^gg
Chapter 9: Event Procedures 192.
Worksheet Events !99
Enable Events 200
Worksheet Calculate 201
Chart Events 202
Before Double Click 202
Workbook Events 205
Save Changes 206
Headers and Footers 207
Summary 208
Contents
Qhapter 10; Adding Controls 202.
Form and ActiveX Controls 209
ActiveX Controls 210
Scrollbar Control 211
Spin Button Control 211
CheckBox Control 212
Option Button Controls 212
Forms Controls 214
Dynamic ActiveX Controls 216
Controls on Charts 220
Summary 221
Chapter 11: Text Files and File Pialog 223
Opening Text Files 223
Writing to Text Files 224
Reading Text Files 226
Writing to Text Files Using Print 227
Reading Data Strings 229
Flexible Separators and Delimiters 230
FileDialog 233
FileDialogFilters 235
FileDialogSelectedltems 235
Dialog Types 235
Execute Method 235
MultiSelect 236
Summary 238
Chapter 12: Working with XML and the QpertXIVlL File Formats 239L
The Basics of Using XML Data in Excel 240
XML Fundamentals 240
Consuming XML Data Directly 246
Creating and Managing Your Own XML Maps 249
Using VBA to Program XML Processes 253
Programming XML Maps 253
Leveraging DOM and XPath to Manipulate XML Files 258
Using VBA to Program Open XML Files 265
Programming Open XML Files with VBA 266
Programmatically Zipping an Excel Container 267
Summary 272
Contents
ghaPter 13: UserForm«; 273
Displaying a UserForm 273
Creating a UserForm 275
Directly Accessing Controls in UserForms 277
Stopping the Close Button 281
Maintaining a Data List 282
Modeless UserForms 2jjg
Progress Indicator
Variable UserForm Name ,fj
Summary «
Overview
Prerequisites 293
Adding the Customizations ÜÜ*
XMLStructure 294
RibbonX and VBA 295
Control Types 298
Basic Controls 2
Container Controls 2
Control Attributes 300
Control Callbacks 301
Managing Control Images ?Üf
Other RibbonX Elements, Attributes, and Callbacks 30^
Sharing Controls among Multiple Workbooks on8
Updating Controls at Run Time , !
Hooking Built-In Controls
RibbonX in Dictator Applications ^J
Customizing the Office Menü vf0
I Customizing the QAT
| Controlling Tabs, Tab Sets, and Groups ~ o
F Dynamic Controls 313
dropDown, comboBox, and gallery ?Jf
dynamicMenu •:51::
Run ?89 Extenslons for the Ribbon ^
RibbonX Limitations
Summary 317
318
Contents
Chapter 15: Command Bars 319
Toolbars, Menü Bars, and Popups 320
Excel s Built-in Command Bars 322
Controls at All Levels 325
Facelds 328
Creating New Menüs 330
The OnAction Macros 332
Passing Parameter Values 333
Deleting a Menü 334
Creating a Toolbar 335
Popup Menüs 338
Showing Popup Command Bars 342
Table-Driven Command Bar Creation 344
Summary 354
Chapter 16: Class Modules 355
Creating Your Own Objects 356
Property Procedures 357
Creating Collections 359
Class Module Collection 360
Encapsulation 363
Trapping Application Events 363
Embedded Chart Events 365
A Collection of UserForm Controls 368
Referencing Classes Across Projects 370
Summary 371
Chapter 17: Add-ins 3Z3_
Hiding the Code 374
Creating an Add-in 374
Closing Add-ins 375
Code Changes 376
Saving Changes 377
Interface Changes 377
Installing an Add-in 379
Addinlnstall Event 381
Removing an Add-in from the Add-ins List 381
Summary 382
Contents
Chapter 18: Automation Add-Ins and COM Add-Ins 333-
Automation Add-Ins 383
A Simple Add-In — Sequence 384
Registering Automation Add-Ins with Excel 385
Using Automation Add-Ins 386
Introducing the IDTExtensibility2 Interface 388
COM Add-Ins 394
The IDTExtensibility2 Interface (Continued) 395
Registering a COM Add-In with Excel 395
The COM Add-In Designer 396
Summary 409
Chapter 19: Interacting with Other Office Applications -4U.
Establishing the Connection 411
Late Binding 412
Early Binding 414
Opening a Document in Word 416
Accessing an Active Word Document 417
Creating a New Word Document 418
Access and ADO 419
Access, Excel, and, Outlook 420
Better than Mail Merge 423
Readable Document Variables 428
Summary 430
Chapter 20: Data Access with ADO 43i
An Introduction to Structured Query Language (SQL) 431
The SELECT Statement 432
The INSERT Statement 434
The UPDATE Statement 434
The DELETE Statement 435
An Overview of ADO 436
The Connection Object 437
The Recordset Object 441
The Command Object 445
Using ADO in Microsoft Excel Applications 447
Using ADO with Microsoft Access 448
Using ADO with Microsoft SQL Server 454
Using ADO with Non-Standard Data Sources 463
Summary 468
Contents
Chapter 21: Managing External Data 469
The External Data User Interface 469
Get External Data 470
Manage Connections 471
The QueryTable and ListObject 472
A QueryTable from a Relational Database 472
A Query Table Associated with a ListObject 475
QueryTables and Parameter Queries 476
QueryTables from Web Queries 479
A QueryTable from a Text File 482
Creating and Using Connection Files 484
The WorkbookConnection Object and the Connections Collection 487
External Data Security Settings 489
Summary 490
Chapter 22: The Trust Center and Document Security 491
The Trust Center 491
Trusted Publishers 492
Trusted Locations 492
Add-ins 494
ActiveX Settings 495
Macro Settings 497
Message Bar 498
External Content 499
Privacy Options 501
Automating Document Inspection 503
The RemoveDocumentlnformation Method 503
The Documentlnspectors Collection 505
Summary 506
Chapter 23: Browsing OLAP Data Sources with Excel 5Q7_
Analyzing OLAP Data via Pivot Tables 508
Connecting to an OLAP Data Source 508
Browsing the OLAP Data Source 510
Understanding the MDX behind OLAP-based Pivot Tables 512
The Basics of MDX 513
Browsing OLAP Data Sources without Pivot Tabies 517
Using ADO to Return Flattened Recordsets 517
Using ADO MD to Get Cube Schema Information 518
Creating an Inventory of Dimensions, Hierarchies, and Levels 519
Contents
Creating Offline Cubes 521
Creating an Offline Cube Manually 521
Using the CreateCubeFile Method 521
Creating an Offline Cube Using ADO MD and VBA 522
Summary 523
Chapter 24: Excel and the Internet 525
What Can the Internet Do for You? 526
Using the Internet for Storing Workbooks 526
Using the Internet as a Data Source 527
Opening Web Pages as Workbooks 528
Using Web Queries 528
Parsing Web Pages for Specific Information 530
Using the Internet to Publish Results 531
Setting Up a Web Server 532
Saving Worksheets as Web Pages 532
Creating Interactive Web Pages 533
Using the Internet as a Communication Channel 533
Communicating with a Web Server 534
Summary 536
Chaoter 25: Internat!^ ic^„^ 532.
Changing Windows Regional Settings and the Office 2007 Ul Language 537
Responding to Regional Settings and the Windows Language 538
Identifying the User s Regional Settings and Windows Language 538
VBA Conversion Functions from an International Perspective 539
Interacting with Excel 545
Sending Data to Excel 545
Reading Data from Excel 54g
The Rules for Working with Excel 548
Interacting with Users 54g
Paper Sizes 549
Displaying Data 549
Interpreting Data 550
The xxxLocal Properties 550
The Rules for Working with Your Users 551
Excel 2007 s International Options 552
Features That Don t Play by the Rules 554
The OpenText Function 555
The SaveAs Function 555
The ShowDataForm Sub Procedure 556
Contents
Pasting Text 557
PivotTable Calculated Fields and Items, and Conditional Format and
Data Validation Formulas 557
Web Queries 558
=TEXT() Worksheet Function 558
The Range.Value, Range.Formula, and Range.FormulaArray Properties 559
The Range.AutoFilter Method 559
The Range.AdvancedFilter Method 559
The Application.Evaluate, Application.ConvertFormula, and
Application.ExecuteExcel4Macro Functions 560
Responding to Office 2007 Language Settings 560
Where Does the Text Come From? 560
Identifying the Office Ul Language Settings 562
Creating a Multilingual Application 562
Working in a Multilingual Environment 564
The Rules for Developing a Multilingual Application 565
Some Helpful Functions 565
The bWinToNum Function 566
The bWinToDate Function 566
The sFormatDate Function 567
The ReplaceHolders Function 568
Summary 568
Chapter 26: Programming the VBE 5Z1.
Identifying VBE Objects in Code 572
The VBE Object 572
The VBProject Object 572
The VBComponent Object 573
The CodeModule Object 574
The CodePane Object 574
The Designer Object 574
Starting Up 575
Adding Menü Items to the VBE 576
Working with Workbooks 580
Working with Code 589
Working with UserForms 594
Working with References 598
COM Add-ins 599
Summary 600
Contents
Chapter 27: Programming with the Windows API 601
Anatomy of an API Call 602
Interpreting C-Style Declarations 603
Constants, Structures, Handies, and Classes 606
What If Something Goes Wrong? 609
Wrapping API Calls in Class Modules 611
Some Example Classes 616
A High-Resolution Timer Class 616
Class Module CHighResTimer 616
Freeze a UserForm 618
A System Info Class 619
Modifying UserForm Styles 622
Window Styles 623
The CFormChanger Class 624
Resizable UserForms 625
Absolute Changes 626
Relative Changes 627
The CFormResizer Class 628
Summary 634
Appendix A: Excel 2007 Object Model 635
Appendix B: VBE Object Model 971
Appendix C: Office 2007 Object Model 935.
Index 1079
|
| any_adam_object | 1 |
| author | Green, John |
| author_facet | Green, John |
| author_role | aut |
| author_sort | Green, John |
| author_variant | j g jg |
| building | Verbundindex |
| bvnumber | BV036069571 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.4.M523 |
| callnumber-search | HF5548.4.M523 |
| callnumber-sort | HF 45548.4 M523 |
| callnumber-subject | HF - Commerce |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)255270597 (DE-599)GBV518658309 |
| 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 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01909nam a2200481 c 4500</leader><controlfield tag="001">BV036069571</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130813 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100309s2007 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0470046430</subfield><subfield code="c">(pbk) : £25.99</subfield><subfield code="9">0-470-04643-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470046432</subfield><subfield code="c">(pbk) : £25.99</subfield><subfield code="9">978-0-470-04643-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)255270597</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV518658309</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-862</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">22</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">Green, John</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel 2007 VBA</subfield><subfield code="b">programmer's reference</subfield><subfield code="c">John Green ....</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Excel 2007 VBA programmer's reference</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Indianapolis, Ind.</subfield><subfield code="b">Wrox, Wiley</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXX, 1143 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield><subfield code="c">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="490" ind1="0" ind2=" "><subfield code="a">Programmer to programmer</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Wrox programmer's references</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business / Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business</subfield><subfield code="x">Computer programs</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 2007</subfield><subfield code="0">(DE-588)7558101-2</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="856" ind1="4" ind2=" "><subfield code="m">DE-605</subfield><subfield code="q">pdf/application</subfield><subfield code="u">http://www.gbv.de/dms/hbz/toc/ht015320208.pdf</subfield><subfield code="x">2008-11-15</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ 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=018960875&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-018960875</subfield></datafield></record></collection> |
| id | DE-604.BV036069571 |
| illustrated | Illustrated |
| indexdate | 2025-02-20T06:43:00Z |
| institution | BVB |
| isbn | 0470046430 9780470046432 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-018960875 |
| oclc_num | 255270597 |
| open_access_boolean | |
| owner | DE-862 DE-BY-FWS |
| owner_facet | DE-862 DE-BY-FWS |
| physical | XXX, 1143 S. Ill., graph. Darst. 24 cm |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Wrox, Wiley |
| record_format | marc |
| series2 | Programmer to programmer Wrox programmer's references |
| spellingShingle | Green, John Excel 2007 VBA programmer's reference Microsoft Excel (Computer file) Business / Computer programs Wirtschaft Business Computer programs VisualBASIC für Applikationen (DE-588)4341325-0 gnd Excel 2007 (DE-588)7558101-2 gnd |
| subject_GND | (DE-588)4341325-0 (DE-588)7558101-2 |
| title | Excel 2007 VBA programmer's reference |
| title_alt | Excel 2007 VBA programmer's reference |
| title_auth | Excel 2007 VBA programmer's reference |
| title_exact_search | Excel 2007 VBA programmer's reference |
| title_full | Excel 2007 VBA programmer's reference John Green .... |
| title_fullStr | Excel 2007 VBA programmer's reference John Green .... |
| title_full_unstemmed | Excel 2007 VBA programmer's reference John Green .... |
| title_short | Excel 2007 VBA |
| title_sort | excel 2007 vba programmer s reference |
| title_sub | programmer's reference |
| topic | Microsoft Excel (Computer file) Business / Computer programs Wirtschaft Business Computer programs VisualBASIC für Applikationen (DE-588)4341325-0 gnd Excel 2007 (DE-588)7558101-2 gnd |
| topic_facet | Microsoft Excel (Computer file) Business / Computer programs Wirtschaft Business Computer programs VisualBASIC für Applikationen Excel 2007 |
| url | http://www.gbv.de/dms/hbz/toc/ht015320208.pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018960875&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT greenjohn excel2007vbaprogrammersreference |
Indexes
Indexes
Indexes
THWS Schweinfurt Teilbibliothek Logistik
| Call Number: |
2350 ST 371 E91 G796 |
|---|---|
| Copy 1 | nicht ausleihbar Available Place a Hold |