Programming Excel with VBA and .NET:
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With...
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing
O'Reilly
2006
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Zusammenfassung: | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages |
| Beschreibung: | XXI, 1090 S. |
| ISBN: | 0596007663 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV021816017 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 061117s2006 |||| 00||| eng d | ||
| 015 | |a 06,N09,0057 |2 dnb | ||
| 016 | 7 | |a 97822728X |2 DE-101 | |
| 020 | |a 0596007663 |c Kt. : EUR 48.00 (freier Pr.), EUR 51.90 (AT) (freier Pr.), sfr 78.90 (freier Pr.) |9 0-596-00766-3 | ||
| 024 | 3 | |a 9780596007669 | |
| 035 | |a (OCoLC)493650865 | ||
| 035 | |a (DE-599)BVBBV021816017 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-706 | ||
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Webb, Jeff |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Programming Excel with VBA and .NET |c Jeff Webb ; Steve Saunders |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing |b O'Reilly |c 2006 | |
| 300 | |a XXI, 1090 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 520 | 3 | |a Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes | |
| 520 | 3 | |a VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects | |
| 520 | 3 | |a With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages | |
| 650 | 4 | |a Microsoft .NET Framework | |
| 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 |
| 650 | 0 | 7 | |a Microsoft dot net |0 (DE-588)4645646-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a EXCEL |0 (DE-588)4138932-3 |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 Microsoft dot net |0 (DE-588)4645646-6 |D s |
| 689 | 1 | |5 DE-604 | |
| 700 | 1 | |a Saunders, Steve |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch Darmstadt |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015028228&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015028228 | ||
Datensatz im Suchindex
| _version_ | 1804135739223441408 |
|---|---|
| adam_text | PROGRAMMING EXCEL WITH VBA AND.NET JEJFWEBB AND STEVE SOUNDERS O REILLY
8 BEIJING * CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI *
TOKYO TABLE OF CONTENTS PREFACE XV PART I. LEARNING VBA 1. BECOMING AN
EXCEL PROGRAMMER 3 WHY PROGRAM? 3 RECORD AND READ CODE 4 CHANGE
RECORDED^CODE 8 FIX MISTEAKES 11 START AND STOP . . 20 VIEW RESULTS 21
WHERE S MY CODE? 26 MACROS AND SECURITY 27 WRITE BUG-FREE CODE , 30
NAVIGATE SAMPLES AND HELP 32 WHAT YOU VE LEARNED 34 2. KNOWING THE
BASICS 35 PARTS OF A PROGRAM * 35 CLASSES AND MODULES * 36 PROCEDURES 40
VARIABLES 50 CONDITIONAL STATEMENTS 65 LOOPS 67 EXPRESSIONS 71
EXCEPTIONS *» 72 WHAT YOU VE LEARNED 74 3. TASKS IN VISUAL BASIC 75
TYPES OF TASKS 75 INTERACT WITH USERS 76 DO MATH 79 WORK WITH TEXT 81
GET DATES AND TIMES 90 READ AND WRITE FILES 92 CHECK RESULTS 100 FIND
TRUTH 103 COMPARE BITS 104 RUN OTHER APPLICATIONS 106 CONTROL THE
COMPILER 112 NOT COVERED HERE 112 WHAT YOU VE LEARNED 113 4. USING EXCEL
OBJECTS 114 OBJECTS AND THEIR MEMBERS 114 GET EXCEL OBJECTS 117 GET
OBJECTS FROM COLLECTIONS 120 ABOUT ME AND THE ACTIVE OBJECT . 123 FIND
THE RIGHT OBJECT 126 COMMON MEMBERS 136 RESPOND TO EVENTS IN EXCEL 142
THE GLOBAL OBJECT 147 THE WORKSHEETFUNCTION OBJECT 147 WHAT YOU VE
LEARNED 155 5. CREATING YOUR OWN OBJECTS 156 MODULES VERSUS CLASSES 156
ADD METHODS ., 159 CREATE PROPERTIES . 160 DEFINE ENUMERATIONS 164 RAISE
EVENTS 165 COLLECT OBJECTS 168 EXPOSE OBJECTS 170 DESTROY OBJECTS 172
THINGS YOU CAN T DO 174 WHAT YOU VE LEARNED 175 TABLE OF CONTENTS 6.
WRITING CODE FOR USE BY OTHERS 176 TYPES OF APPLICATIONS 176 THE
DEVELOPMENT PROCESS 177 DETERMINE REQUIREMENTS 179 DESIGN 180 IMPLEMENT
AND TEST 180 INTEGRATE 181 TEST PLATFORMS 183 DOCUMENT 185 DEPLOY 188
WHAT YOU VE LEARNED 195 RESOURCES 196 PART II. EXCEL OBJECTS 7.
CONTROLLING EXCEL 199 PERFORM TASKS 199 CONTROL EXCEL OPTIONS . 203 GET
REFERENCES 205 APPLICATION MEMBERS 207 AUTOCORRECT MEMBERS 250
AUTORECOVER MEMBERS * 252 ERRORCHECKING MEMBERS 253 SPELLINGOPTIONS
MEMBERS 253 WINDOW AND WINDOWS MEMBERS 255 PANE AND PANES MEMBERS 264 8.
OPENING, SAVING, AND SHARING WORKBOOKS 266 ADD, OPEN, SAVE, AND CLOSE
267 SHARE WORKBOOKS 276 PROGRAM WITH SHARED WORKBOOKS 279 PROGRAM WITH
SHARED WORKSPACES 282 RESPOND TO ACTIONS 288 WORKBOOK AND WORKBOOKS
MEMBERS 292 RECENTFILE AND RECENTFILES MEMBERS 328 TABLE OF CONTENTS I
VII 9. WORKING WITH WORKSHEETS AND RANGES 330 WORK WITH WORKSHEET
OBJECTS 331 WORKSHEETS AND WORKSHEET MEMBERS 332 SHEETS MEMBERS 340 WORK
WITH OUTLINES 341 OUTLINE MEMBERS 342 WORK WITH RANGES 343 RANGE MEMBERS
347 WORK WITH SCENARIO OBJECTS 366 SCENARIO AND SCENARIOS MEMBERS 367
RESOURCES 368 10. LINKING AND EMBEDDING 369 ADD COMMENTS 369 USE
HYPERLINKS 370 LINK AND EMBED OBJECTS 372 SPEAK 378 COMMENT AND COMMENTS
MEMBERS 379 HYPERLINK AND HYPERLINKS MEMBERS 380 OLEOBJECT AND
OLEOBJECTS MEMBERS 383 OLEFORMAT MEMBERS 388 SPEECH MEMBERS 388
USEDOBJECTS MEMBERS 389 11. PRINTING AND PUBLISHING 391 PRINT AND
PREVIEW 391 CONTROL PAGING 392 CHANGE PRINTER SETTINGS 393 FILTER RANGES
395 SAVE AND DISPLAY VIEWS ., 397 PUBLISH TO THE WEB . 399 AUTOFILTER
MEMBERS 402 FILTER AND FILTERS MEMBERS 403 CUSTOMVIEW AND CUSTOMVIEWS
MEMBERS 404 HPAGEBREAK, HPAGEBREAKS, VPAGEBREAK, VPAGEBREAKS MEMBERS 405
PAGESETUP MEMBERS 406 GRAPHIC MEMBERS 412 PUBLISHOBJECTJAND
PUBLISHOBJECTS MEMBERS 414 WEBOPTIONS AND DEFAULTWEBOPTIONS MEMBERS 416
VIII I TABLE OF CONTENTS 12. LOADING AND MANIPULATING DATA 421 WORKING
WITH QUERYTABLE OBJECTS 422 QUERYTABLE AND QUERYTABLES MEMBERS 423
WORKING WITH PARAMETER OBJECTS 433 PARAMETER MEMBERS 434 WORKING WITH
ADO AND DAO 437 ADO OBJECTS AND MEMBERS 437 DAO OBJECTS AND MEMBERS 450
DAO.DATABASE AND DAO.DATABASES MEMBERS 450 DAO.DOCUMENT AND
DAO.DOCUMENTS MEMBERS 453 DAO.QUERYDEF AND DAO.QUERYDEFS MEMBERS 453
DAO.RECORDSET AND DAO.RECORDSETS MEMBERS 455 13. ANALYZING DATA WITH
PIVOT TABLES 458 QUICK GUIDE TO PIVOT TABLES 458 PROGRAM PIVOT TABLES
471 PIVOTTABLE AND PIVOTTABLES MEMBERS 476 PIVOTCACHE AND PIVOTCACHES
MEMBERS 491 PIVOTFIELD AND PIVOTFIELDS MEMBERS 499 CALCULATEDFIELDS
MEMBERS 510 CALCULATEDLTEMS MEMBERS - 511 PIVOTCELL MEMBERS 513
PIVOTFORMULA AND PIVOTFORMULAS MEMBERS 514 PIVOTLTEM AND PIVOTLTEMS
MEMBERS 514 PIVOTLTEMLIST MEMBERS 515 PIVOTLAYOUT MEMBERS 516 CUBEFIELD
AND CUBEFIELDS MEMBERS 517 CALCULATEDMEMBER AND CALCULATEDMEMBERS
MEMBERS 519 14. SHARING DATA USING LISTS 520 USE LISTS . 521 LISTOBJECT
AND LISTOBJECTS MEMBERS 529 LISTROW AND LISTROWS MEMBERS 534 LISTCOLUMN
AND LISTCOLUMNS MEMBERS 536 LISTDATAFORMAT MEMBERS 537 USE THE LISTS WEB
SERVICE 540 LISTS WEB SERVICE MEMBERS 548 RESOURCES * 552 TABLE OF
CONTENTS 15. WORKING WITH XML 553 UNDERSTAND XML 554 SAVE WORKBOOKS AS
XML 555 USE XML MAPS 568 PROGRAM WITH XML MAPS 583 XMLMAP AND XMLMAPS
MEMBERS 585 XMLDATABINDING MEMBERS 590 XMLNAMESPACE AND XMLNAMESPACES
MEMBERS 591 XMLSCHEMA AND XMLSCHEMAS MEMBERS 593 GET AN XML MAP FROM A
LIST OR RANGE 594 XPATH MEMBERS 595 RESOURCES 597 16. CHARTING 598
NAVIGATE CHART OBJECTS 598 CREATE CHARTS QUICKLY 598 EMBED CHARTS 601
CREATE MORE COMPLEX CHARTS 602 CHOOSE CHART TYPE 604 CREATE COMBO CHARTS
606 ADD TITLES AND LABELS 607 PLOT A SERIES 609 RESPOND TO CHART EVENTS
610 CHART AND CHARTS MEMBERS 611 CHARTOBJECT AND CHARTOBJECTS MEMBERS
629 CHARTGROUP AND CHARTGROUPS MEMBERS 630 SERIESLINES MEMBERS 634 AXES
AND AXIS MEMBERS 635 DATATABLE MEMBERS 643 SERIES AND SERIESCOLLECTION
MEMBERS 644 POINT AND POINTS MEMBERS - 655 17. FORMATTING CHARTS 657
FORMAT TITLES AND LABELS 657 CHANGE BACKGROUNDS AND FONTS . 659 ADD
TRENDLINES 662 ADD SERIES LINES AND BARS 663 CHARTTITLE, AXISTITLE, AND
DISPLAYUNITLABEL MEMBERS 664 TABLE OF CONTENTS DATALABEL AND DATALABELS
MEMBERS 666 LEADERLINES MEMBERS 671 CHARTAREA MEMBERS 672
CHARTFILLFORMAT MEMBERS 674 CHARTCOLORFORMAT MEMBERS * 681 DROPLINES AND
HILOLINES MEMBERS 682 DOWNBARS AND UPBARS MEMBERS 682 ERRORBARS MEMBERS
683 LEGEND MEMBERS 684 LEGENDENTRY AND LEGENDENTRIES MEMBERS 685
LEGENDKEY MEMBERS 686 GRIDLINES MEMBERS 688 TICKLABELS MEMBERS 688
TRENDLINE AND TRENDLINES MEMBERS 690 PLOTAREA MEMBERS 693 FLOOR MEMBERS
696 WALLS MEMBERS 696 CORNERS MEMBERS 697 18. DRAWING GRAPHICS 698 DRAW
IN EXCEL 698 CREATE DIAGRAMS 700 PROGRAM WITH DRAWING OBJECTS 700
PROGRAM DIAGRAMS 707 SHAPE, SHAPERANGE, AND SHAPES MEMBERS 709
ADJUSTMENTS MEMBERS 729 CALLOUTFORMAT MEMBERS 729 COLORFORMAT MEMBERS
732 CONNECTORFORMAT MEMBERS 732 CONTROLFORMAT MEMBERS ^ 734 FILLFORMAT
MEMBERS - 735 FREEFORMBUILDER 736 GROUPSHAPES MEMBERS 737 LINEFORMAT
MEMBERS 738 LINKFORMAT MEMBERS 738 PICTUREFORMAT MEMBERS 739
SHADOWFORMAT 740 TABLE OF CONTENTS SHAPENODE AND SHAPENODES MEMBERS 741
TEXTFRAME 742 TEXTEFFECTFORMAT 745 THREEDFORMAT 748 19. ADDING MENUS AND
TOOLBARS 749 ABOUT EXCEL MENUS 749 BUILD A TOP-LEVEL MENU 750 CREATE A
MENU IN CODE 756 BUILD CONTEXT MENUS 760 BUILD A TOOLBAR 764 CREATE
TOOLBARS IN CODE 767 COMMANDBAR AND COMMANDBARS MEMBERS 771
COMMANDBARCONTROL AND COMMANDBARCONTROLS MEMBERS 779 COMMANDBARBUTTON
MEMBERS 784 COMMANDBARCOMBOBOX MEMBERS 787 COMMANDBARPOPUP MEMBERS 790
20. BUILDING DIALOG BOXES 793 TYPES OF DIALOGS 793 CREATE DATA-ENTRY
FORMS 794 DESIGN YOUR OWN FORMS 798 USE CONTROLS ON WORKSHEETS V . 813
USERFORM AND FRAME MEMBERS 818 CONTROL AND CONTROLS MEMBERS 826 FONT
MEMBERS 831 CHECKBOX, OPTIONBUTTON, TOGGLEBUTTON MEMBERS 832 COMBOBOX
MEMBERS 833 COMMANDBUTTON MEMBERS 840 IMAGE MEMBERS ._ 841 LABEL MEMBERS
842 LISTBOX MEMBERS 842 MULTIPAGE MEMBERS 843 PAGE MEMBERS 845 SCROLLBAR
AND SPINBUTTON MEMBERS 846 TABSTRIP MEMBERS 847 TEXTBOX AND REFEDIT
MEMBERS 849 XII I TABLE OF CONTENTS 21. SENDING AND RECEIVING WORKBOOKS
SEND MAIL WORK WITH MAIL ITEMS COLLECT REVIEW COMMENTS ROUTE WORKBOOKS
READ MAIL MSOENVELOPE MEMBERS MAILLTEM MEMBERS ROUTINGSLIP MEMBERS PART
III. EXTENDING EXCEL 22. BUILDING ADD-INS TYPES OF ADD-INS CODE-ONLY
ADD-INS VISUAL ADD-INS SET ADD-IN PROPERTIES SIGN THE ADD-IN DISTRIBUTE
THE ADD-IN WORK WITH ADD-INS IN CODE ADDLN AND ADDLNS MEMBERS 23.
INTEGRATING DLLS AND COM USE DLLS USE COM APPLICATIONS 24. GETTING DATA
FROM THE WEB PERFORM WEB QUERIES QUERYTABLE AND QUERYTABLES WEB QUERY
MEMBERS USE WEB SERVICES RESOURCES 25. PROGRAMMING EXCEL WITH .NET ..
APPROACHES TO WORKING WITH .NET CREATE .NET COMPONENTS FOR EXCEL USE
.NET COMPONENTS IN EXCEL USE EXCEL AS A COMPONENT IN .NET CREATE EXCEL
APPLICATIONS IN .NET RESOURCES 852 852 854 857 858 860 860 861 866 871
871 872 877 881 882 883 884 884 887 887 894 902 903 913 922 932 933 934
934 937 946 954 969 TABLE OF CONTENTS 1 XIII 26. EXDLORINA SECURITY IN
DEPTH .. SECURITY LAYERS UNDERSTAND WINDOWS SECURITY PASSWORD-PROTECT
AND ENCRYPT WORKBOOKS PROGRAM WITH PASSWORDS AND ENCRYPTION WORKBOOK
PASSWORD AND ENCRYPTION MEMBERS EXCEL PASSWORD SECURITY PROTECT ITEMS IN
A WORKBOOK PROGRAM WITH PROTECTION WORKBOOK PROTECTION MEMBERS WORKSHEET
PROTECTION MEMBERS CHART PROTECTION MEMBERS PROTECTION MEMBERS
ALLOWEDITRANGE AND ALLOWEDITRANGES MEMBERS USERACCESS AND USERACCESSLIST
MEMBERS SET WORKBOOK PERMISSIONS PROGRAM WITH PERMISSIONS PERMISSION AND
USERPERMISSION MEMBERS ADD DIGITAL SIGNATURES SET MACRO SECURITY SET
ACTIVEX CONTROL SECURITY DISTRIBUTE SECURITY SETTINGS USING THE
ANTI-VIRUS API COMMON TASKS RESOURCES 970 970 971 975 976 978 980 981
985 988 990 992 994 996 998 999 1003 1005 1008 1008 1010 1011 1014 1015
1016 PART IV. APPENDIXES A. REFERENCE TABLES T 1019 B. VERSION
COMPATIBILITY *. 1031 INDEX 1039 XIV | TABLE OF CONTENTS
|
| adam_txt |
PROGRAMMING EXCEL WITH VBA AND.NET JEJFWEBB AND STEVE SOUNDERS O'REILLY
8 BEIJING * CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI *
TOKYO TABLE OF CONTENTS PREFACE XV PART I. LEARNING VBA 1. BECOMING AN
EXCEL PROGRAMMER 3 WHY PROGRAM? 3 RECORD AND READ CODE ' 4 CHANGE
RECORDED^CODE 8 FIX MISTEAKES 11 START AND STOP . . 20 VIEW RESULTS 21
WHERE'S MY CODE? 26 MACROS AND SECURITY 27 WRITE BUG-FREE CODE , 30
NAVIGATE SAMPLES AND HELP 32 WHAT YOU'VE LEARNED 34 2. KNOWING THE
BASICS 35 PARTS OF A PROGRAM * 35 CLASSES AND MODULES * 36 PROCEDURES 40
VARIABLES 50 CONDITIONAL STATEMENTS 65 LOOPS 67 EXPRESSIONS 71
EXCEPTIONS *»" 72 WHAT YOU'VE LEARNED 74 3. TASKS IN VISUAL BASIC 75
TYPES OF TASKS 75 INTERACT WITH USERS 76 DO MATH 79 WORK WITH TEXT 81
GET DATES AND TIMES 90 READ AND WRITE FILES 92 CHECK RESULTS 100 FIND
TRUTH 103 COMPARE BITS 104 RUN OTHER APPLICATIONS 106 CONTROL THE
COMPILER 112 NOT COVERED HERE 112 WHAT YOU'VE LEARNED 113 4. USING EXCEL
OBJECTS 114 OBJECTS AND THEIR MEMBERS 114 GET EXCEL OBJECTS 117 GET
OBJECTS FROM COLLECTIONS 120 ABOUT ME AND THE ACTIVE OBJECT . 123 FIND
THE RIGHT OBJECT 126 COMMON MEMBERS 136 RESPOND TO EVENTS IN EXCEL ' 142
THE GLOBAL OBJECT 147 THE WORKSHEETFUNCTION OBJECT 147 WHAT YOU'VE
LEARNED 155 5. CREATING YOUR OWN OBJECTS 156 MODULES VERSUS CLASSES 156
ADD METHODS ., 159 CREATE PROPERTIES . 160 DEFINE ENUMERATIONS 164 RAISE
EVENTS 165 COLLECT OBJECTS 168 EXPOSE OBJECTS 170 DESTROY OBJECTS 172
THINGS YOU CAN'T DO 174 WHAT YOU'VE LEARNED 175 TABLE OF CONTENTS 6.
WRITING CODE FOR USE BY OTHERS 176 TYPES OF APPLICATIONS 176 THE
DEVELOPMENT PROCESS 177 DETERMINE REQUIREMENTS 179 DESIGN 180 IMPLEMENT
AND TEST 180 INTEGRATE 181 TEST PLATFORMS 183 DOCUMENT 185 DEPLOY 188
WHAT YOU'VE LEARNED 195 RESOURCES 196 PART II. EXCEL OBJECTS 7.
CONTROLLING EXCEL 199 PERFORM TASKS 199 CONTROL EXCEL OPTIONS . 203 GET
REFERENCES 205 APPLICATION MEMBERS 207 AUTOCORRECT MEMBERS 250
AUTORECOVER MEMBERS '* 252 ERRORCHECKING MEMBERS 253 SPELLINGOPTIONS
MEMBERS 253 WINDOW AND WINDOWS MEMBERS 255 PANE AND PANES MEMBERS 264 8.
OPENING, SAVING, AND SHARING WORKBOOKS 266 ADD, OPEN, SAVE, AND CLOSE
267 SHARE WORKBOOKS 276 PROGRAM WITH SHARED WORKBOOKS 279 PROGRAM WITH
SHARED WORKSPACES 282 RESPOND TO ACTIONS 288 WORKBOOK AND WORKBOOKS
MEMBERS 292 RECENTFILE AND RECENTFILES MEMBERS 328 TABLE OF CONTENTS I
VII 9. WORKING WITH WORKSHEETS AND RANGES 330 WORK WITH WORKSHEET
OBJECTS 331 WORKSHEETS AND WORKSHEET MEMBERS 332 SHEETS MEMBERS 340 WORK
WITH OUTLINES 341 OUTLINE MEMBERS 342 WORK WITH RANGES 343 RANGE MEMBERS
347 WORK WITH SCENARIO OBJECTS 366 SCENARIO AND SCENARIOS MEMBERS 367
RESOURCES 368 10. LINKING AND EMBEDDING 369 ADD COMMENTS 369 USE
HYPERLINKS 370 LINK AND EMBED OBJECTS 372 SPEAK 378 COMMENT AND COMMENTS
MEMBERS 379 HYPERLINK AND HYPERLINKS MEMBERS 380 OLEOBJECT AND
OLEOBJECTS MEMBERS 383 OLEFORMAT MEMBERS 388 SPEECH MEMBERS 388
USEDOBJECTS MEMBERS ' 389 11. PRINTING AND PUBLISHING 391 PRINT AND
PREVIEW 391 CONTROL PAGING 392 CHANGE PRINTER SETTINGS 393 FILTER RANGES
395 SAVE AND DISPLAY VIEWS ., 397 PUBLISH TO THE WEB . 399 AUTOFILTER
MEMBERS 402 FILTER AND FILTERS MEMBERS 403 CUSTOMVIEW AND CUSTOMVIEWS
MEMBERS 404 HPAGEBREAK, HPAGEBREAKS, VPAGEBREAK, VPAGEBREAKS MEMBERS 405
PAGESETUP MEMBERS 406 GRAPHIC MEMBERS 412 PUBLISHOBJECTJAND
PUBLISHOBJECTS MEMBERS 414 WEBOPTIONS AND DEFAULTWEBOPTIONS MEMBERS 416
VIII I TABLE OF CONTENTS 12. LOADING AND MANIPULATING DATA 421 WORKING
WITH QUERYTABLE OBJECTS 422 QUERYTABLE AND QUERYTABLES MEMBERS 423
WORKING WITH PARAMETER OBJECTS 433 PARAMETER MEMBERS 434 WORKING WITH
ADO AND DAO 437 ADO OBJECTS AND MEMBERS 437 DAO OBJECTS AND MEMBERS 450
DAO.DATABASE AND DAO.DATABASES MEMBERS 450 DAO.DOCUMENT AND
DAO.DOCUMENTS MEMBERS 453 DAO.QUERYDEF AND DAO.QUERYDEFS MEMBERS 453
DAO.RECORDSET AND DAO.RECORDSETS MEMBERS 455 13. ANALYZING DATA WITH
PIVOT TABLES 458 QUICK GUIDE TO PIVOT TABLES 458 PROGRAM PIVOT TABLES
471 PIVOTTABLE AND PIVOTTABLES MEMBERS 476 PIVOTCACHE AND PIVOTCACHES
MEMBERS 491 PIVOTFIELD AND PIVOTFIELDS MEMBERS 499 CALCULATEDFIELDS
MEMBERS 510 CALCULATEDLTEMS MEMBERS - 511 PIVOTCELL MEMBERS 513
PIVOTFORMULA AND PIVOTFORMULAS MEMBERS 514 PIVOTLTEM AND PIVOTLTEMS
MEMBERS 514 PIVOTLTEMLIST MEMBERS 515 PIVOTLAYOUT MEMBERS 516 CUBEFIELD
AND CUBEFIELDS MEMBERS 517 CALCULATEDMEMBER AND CALCULATEDMEMBERS
MEMBERS 519 14. SHARING DATA USING LISTS 520 USE LISTS . 521 LISTOBJECT
AND LISTOBJECTS MEMBERS 529 LISTROW AND LISTROWS MEMBERS 534 LISTCOLUMN
AND LISTCOLUMNS MEMBERS 536 LISTDATAFORMAT MEMBERS 537 USE THE LISTS WEB
SERVICE 540 LISTS WEB SERVICE MEMBERS 548 RESOURCES * 552 TABLE OF
CONTENTS 15. WORKING WITH XML 553 UNDERSTAND XML 554 SAVE WORKBOOKS AS
XML 555 USE XML MAPS 568 PROGRAM WITH XML MAPS 583 XMLMAP AND XMLMAPS
MEMBERS 585 XMLDATABINDING MEMBERS 590 XMLNAMESPACE AND XMLNAMESPACES
MEMBERS 591 XMLSCHEMA AND XMLSCHEMAS MEMBERS 593 GET AN XML MAP FROM A
LIST OR RANGE 594 XPATH MEMBERS 595 RESOURCES 597 16. CHARTING 598
NAVIGATE CHART OBJECTS 598 CREATE CHARTS QUICKLY 598 EMBED CHARTS 601
CREATE MORE COMPLEX CHARTS 602 CHOOSE CHART TYPE 604 CREATE COMBO CHARTS
606 ADD TITLES AND LABELS 607 PLOT A SERIES 609 RESPOND TO CHART EVENTS
610 CHART AND CHARTS MEMBERS 611 CHARTOBJECT AND CHARTOBJECTS MEMBERS
629 CHARTGROUP AND CHARTGROUPS MEMBERS 630 SERIESLINES MEMBERS 634 AXES
AND AXIS MEMBERS 635 DATATABLE MEMBERS 643 SERIES AND SERIESCOLLECTION
MEMBERS 644 POINT AND POINTS MEMBERS - 655 17. FORMATTING CHARTS 657
FORMAT TITLES AND LABELS 657 CHANGE BACKGROUNDS AND FONTS . 659 ADD
TRENDLINES 662 ADD SERIES LINES AND BARS 663 CHARTTITLE, AXISTITLE, AND
DISPLAYUNITLABEL MEMBERS 664 TABLE OF CONTENTS DATALABEL AND DATALABELS
MEMBERS 666 LEADERLINES MEMBERS 671 CHARTAREA MEMBERS 672
CHARTFILLFORMAT MEMBERS 674 CHARTCOLORFORMAT MEMBERS * 681 DROPLINES AND
HILOLINES MEMBERS 682 DOWNBARS AND UPBARS MEMBERS 682 ERRORBARS MEMBERS
683 LEGEND MEMBERS ' 684 LEGENDENTRY AND LEGENDENTRIES MEMBERS 685
LEGENDKEY MEMBERS 686 GRIDLINES MEMBERS 688 TICKLABELS MEMBERS 688
TRENDLINE AND TRENDLINES MEMBERS 690 PLOTAREA MEMBERS 693 FLOOR MEMBERS
696 WALLS MEMBERS 696 CORNERS MEMBERS 697 18. DRAWING GRAPHICS 698 DRAW
IN EXCEL ' 698 CREATE DIAGRAMS 700 PROGRAM WITH DRAWING OBJECTS ' 700
PROGRAM DIAGRAMS 707 SHAPE, SHAPERANGE, AND SHAPES MEMBERS 709
ADJUSTMENTS MEMBERS 729 CALLOUTFORMAT MEMBERS 729 COLORFORMAT MEMBERS
732 CONNECTORFORMAT MEMBERS 732 CONTROLFORMAT MEMBERS ^ 734 FILLFORMAT
MEMBERS - 735 FREEFORMBUILDER 736 GROUPSHAPES MEMBERS 737 LINEFORMAT
MEMBERS 738 LINKFORMAT MEMBERS 738 PICTUREFORMAT MEMBERS 739
SHADOWFORMAT 740 TABLE OF CONTENTS SHAPENODE AND SHAPENODES MEMBERS 741
TEXTFRAME 742 TEXTEFFECTFORMAT 745 THREEDFORMAT 748 19. ADDING MENUS AND
TOOLBARS 749 ABOUT EXCEL MENUS 749 BUILD A TOP-LEVEL MENU 750 CREATE A
MENU IN CODE 756 BUILD CONTEXT MENUS 760 BUILD A TOOLBAR 764 CREATE
TOOLBARS IN CODE 767 COMMANDBAR AND COMMANDBARS MEMBERS 771
COMMANDBARCONTROL AND COMMANDBARCONTROLS MEMBERS 779 COMMANDBARBUTTON
MEMBERS 784 COMMANDBARCOMBOBOX MEMBERS 787 COMMANDBARPOPUP MEMBERS ' 790
20. BUILDING DIALOG BOXES 793 TYPES OF DIALOGS 793 CREATE DATA-ENTRY
FORMS 794 DESIGN YOUR OWN FORMS 798 USE CONTROLS ON WORKSHEETS V . 813
USERFORM AND FRAME MEMBERS 818 CONTROL AND CONTROLS MEMBERS 826 FONT
MEMBERS 831 CHECKBOX, OPTIONBUTTON, TOGGLEBUTTON MEMBERS 832 COMBOBOX
MEMBERS 833 COMMANDBUTTON MEMBERS 840 IMAGE MEMBERS ._ 841 LABEL MEMBERS
842 LISTBOX MEMBERS 842 MULTIPAGE MEMBERS 843 PAGE MEMBERS 845 SCROLLBAR
AND SPINBUTTON MEMBERS 846 TABSTRIP MEMBERS 847 TEXTBOX AND REFEDIT
MEMBERS 849 XII I TABLE OF CONTENTS 21. SENDING AND RECEIVING WORKBOOKS
SEND MAIL WORK WITH MAIL ITEMS COLLECT REVIEW COMMENTS ROUTE WORKBOOKS
READ MAIL MSOENVELOPE MEMBERS MAILLTEM MEMBERS ROUTINGSLIP MEMBERS PART
III. EXTENDING EXCEL 22. BUILDING ADD-INS TYPES OF ADD-INS CODE-ONLY
ADD-INS VISUAL ADD-INS SET ADD-IN PROPERTIES SIGN THE ADD-IN DISTRIBUTE
THE ADD-IN WORK WITH ADD-INS IN CODE ADDLN AND ADDLNS MEMBERS 23.
INTEGRATING DLLS AND COM USE DLLS USE COM APPLICATIONS 24. GETTING DATA
FROM THE WEB PERFORM WEB QUERIES QUERYTABLE AND QUERYTABLES WEB QUERY
MEMBERS USE WEB SERVICES RESOURCES 25. PROGRAMMING EXCEL WITH .NET .
APPROACHES TO WORKING WITH .NET CREATE .NET COMPONENTS FOR EXCEL USE
.NET COMPONENTS IN EXCEL USE EXCEL AS A COMPONENT IN .NET CREATE EXCEL
APPLICATIONS IN .NET RESOURCES 852 852 854 857 858 860 860 861 866 871
871 872 877 881 882 883 884 884 887 887 894 902 903 913 922 932 933 934
934 937 946 954 969 TABLE OF CONTENTS 1 XIII 26. EXDLORINA SECURITY IN
DEPTH . SECURITY LAYERS UNDERSTAND WINDOWS SECURITY PASSWORD-PROTECT
AND ENCRYPT WORKBOOKS PROGRAM WITH PASSWORDS AND ENCRYPTION WORKBOOK
PASSWORD AND ENCRYPTION MEMBERS EXCEL PASSWORD SECURITY PROTECT ITEMS IN
A WORKBOOK PROGRAM WITH PROTECTION WORKBOOK PROTECTION MEMBERS WORKSHEET
PROTECTION MEMBERS CHART PROTECTION MEMBERS PROTECTION MEMBERS
ALLOWEDITRANGE AND ALLOWEDITRANGES MEMBERS USERACCESS AND USERACCESSLIST
MEMBERS SET WORKBOOK PERMISSIONS PROGRAM WITH PERMISSIONS PERMISSION AND
USERPERMISSION MEMBERS ADD DIGITAL SIGNATURES SET MACRO SECURITY SET
ACTIVEX CONTROL SECURITY DISTRIBUTE SECURITY SETTINGS USING THE
ANTI-VIRUS API COMMON TASKS RESOURCES 970 970 971 975 976 978 980 981
985 988 990 992 994 996 998 999 1003 1005 1008 1008 1010 1011 1014 1015
1016 PART IV. APPENDIXES A. REFERENCE TABLES T 1019 B. VERSION
COMPATIBILITY *. 1031 INDEX 1039 XIV | TABLE OF CONTENTS |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Webb, Jeff Saunders, Steve |
| author_facet | Webb, Jeff Saunders, Steve |
| author_role | aut aut |
| author_sort | Webb, Jeff |
| author_variant | j w jw s s ss |
| building | Verbundindex |
| bvnumber | BV021816017 |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)493650865 (DE-599)BVBBV021816017 |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03848nam a2200505 c 4500</leader><controlfield tag="001">BV021816017</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">061117s2006 |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">06,N09,0057</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">97822728X</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596007663</subfield><subfield code="c">Kt. : EUR 48.00 (freier Pr.), EUR 51.90 (AT) (freier Pr.), sfr 78.90 (freier Pr.)</subfield><subfield code="9">0-596-00766-3</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9780596007669</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)493650865</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV021816017</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="049" ind1=" " ind2=" "><subfield code="a">DE-706</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="100" ind1="1" ind2=" "><subfield code="a">Webb, Jeff</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Programming Excel with VBA and .NET</subfield><subfield code="c">Jeff Webb ; Steve Saunders</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2006</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXI, 1090 S.</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="520" ind1="3" ind2=" "><subfield code="a">Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft .NET Framework</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="650" ind1="0" ind2="7"><subfield code="a">Microsoft dot net</subfield><subfield code="0">(DE-588)4645646-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" 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="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">Microsoft dot net</subfield><subfield code="0">(DE-588)4645646-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Saunders, Steve</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch Darmstadt</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=015028228&sequence=000001&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-015028228</subfield></datafield></record></collection> |
| id | DE-604.BV021816017 |
| illustrated | Not Illustrated |
| index_date | 2024-07-02T15:52:32Z |
| indexdate | 2024-07-09T20:45:17Z |
| institution | BVB |
| isbn | 0596007663 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015028228 |
| oclc_num | 493650865 |
| open_access_boolean | |
| owner | DE-706 |
| owner_facet | DE-706 |
| physical | XXI, 1090 S. |
| publishDate | 2006 |
| publishDateSearch | 2006 |
| publishDateSort | 2006 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Webb, Jeff Verfasser aut Programming Excel with VBA and .NET Jeff Webb ; Steve Saunders 1. ed. Beijing O'Reilly 2006 XXI, 1090 S. txt rdacontent n rdamedia nc rdacarrier Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages Microsoft .NET Framework EXCEL (DE-588)4138932-3 gnd rswk-swf VisualBASIC für Applikationen (DE-588)4341325-0 gnd rswk-swf Microsoft dot net (DE-588)4645646-6 gnd rswk-swf EXCEL (DE-588)4138932-3 s VisualBASIC für Applikationen (DE-588)4341325-0 s DE-604 Microsoft dot net (DE-588)4645646-6 s Saunders, Steve Verfasser aut HEBIS Datenaustausch Darmstadt application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015028228&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Webb, Jeff Saunders, Steve Programming Excel with VBA and .NET Microsoft .NET Framework EXCEL (DE-588)4138932-3 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd Microsoft dot net (DE-588)4645646-6 gnd |
| subject_GND | (DE-588)4138932-3 (DE-588)4341325-0 (DE-588)4645646-6 |
| title | Programming Excel with VBA and .NET |
| title_auth | Programming Excel with VBA and .NET |
| title_exact_search | Programming Excel with VBA and .NET |
| title_exact_search_txtP | Programming Excel with VBA and .NET |
| title_full | Programming Excel with VBA and .NET Jeff Webb ; Steve Saunders |
| title_fullStr | Programming Excel with VBA and .NET Jeff Webb ; Steve Saunders |
| title_full_unstemmed | Programming Excel with VBA and .NET Jeff Webb ; Steve Saunders |
| title_short | Programming Excel with VBA and .NET |
| title_sort | programming excel with vba and net |
| topic | Microsoft .NET Framework EXCEL (DE-588)4138932-3 gnd VisualBASIC für Applikationen (DE-588)4341325-0 gnd Microsoft dot net (DE-588)4645646-6 gnd |
| topic_facet | Microsoft .NET Framework EXCEL VisualBASIC für Applikationen Microsoft dot net |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015028228&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT webbjeff programmingexcelwithvbaandnet AT saunderssteve programmingexcelwithvbaandnet |