| 000 | 25294nam a2200469Ia 4500 | ||
|---|---|---|---|
| 001 | 2003 | ||
| 008 | 230305s2016 xx 000 0 und d | ||
| 020 | _a9781119067726 | ||
| 041 | _aeng | ||
| 245 | 0 | _aExcel 2016 power programming with VBA | |
| 260 |
_a _bWiley, _c2016 |
||
| 300 | _axxxii, 729 pages : illustrations ; 23 cm | ||
| 505 |
_aPart I: Introduction to Excel VBA _rChapter 1: Essentials of Spreadsheet Application Development 3 -- _rWhat Is a Spreadsheet Application? 3 -- _rSteps for Application Development 4 -- _rDetermining User Needs 5 -- _rPlanning an Application That Meets User Needs 6 -- _rDetermining the Most Appropriate User Interface 8 -- _rCustomizing the Ribbon 8 -- _rCustomizing shortcut menus 8 -- _rCreating shortcut keys 9 -- _rCreating custom dialog boxes 9 -- _rUsing ActiveX controls on a worksheet 10 -- _rExecuting the development effort 11 -- _rConcerning Yourself with the End User 12 -- _rTesting the application 12 -- _rMaking the application bulletproof 13 -- _rMaking the application aesthetically appealing and intuitive 15 -- _rCreating a user Help system 16 -- _rDocumenting the development effort 16 -- _rDistributing the application to the user 16 -- _rUpdating the application when necessary 17 -- _rOther Development Issues 17 -- _rThe user's installed version of Excel 17 -- _rLanguage issues 17 -- _rSystem speed 18 -- _rVideo modes 18 -- _rChapter 2: Introducing Visual Basic for Applications 19 -- _rGetting a Head Start with the Macro Recorder 19 -- _rCreating your first macro 20 -- _rComparing absolute and relative macro recording 23 -- _rOther macro recording concepts 27 -- _rWorking with the Visual Basic Editor 32 -- _rUnderstanding VBE components 32 -- _rWorking with the Project window 33 -- _rWorking with a Code window 36 -- _rCustomizing the VBA environment 38 -- _rThe Editor Format tab 40 -- _rThe General tab 41 -- _rThe Docking tab 41 -- _rVBA Fundamentals 42 -- _rUnderstanding objects 43 -- _rUnderstanding collections 43 -- _rUnderstanding properties 44 -- _rDeep Dive: Working with Range Objects 47 -- _rFinding the properties of the Range object 48 -- _rThe Range property 48 -- _rThe Cells property 49 -- _rThe Offset property 52 -- _rEssential Concepts to Remember 53 -- _rDon't Panic--You Are Not Alone 55 -- _rRead the rest of the book 55 -- _rLet Excel help write your macro 55 -- _rUse the Help system 55 -- _rUse the Object Browser 56 -- _rPilfer code from the Internet 57 -- _rLeverage user forums 57 -- _rVisit expert blogs 58 -- _rMine YouTube for video training 58 -- _rLearn from the Microsoft Office Dev Center 59 -- _rDissect the other Excel files in your organization 59 -- _rAsk your local Excel genius 59 -- _rChapter 3: VBA Programming Fundamentals 61 -- _rVBA Language Elements: An Overview 61 -- _rComments 63 -- _rVariables, Data Types, and Constants 64 -- _rDefining data types 65 -- _rDeclaring variables 67 -- _rScoping variables 69 -- _rWorking with constants 72 -- _rWorking with strings 73 -- _rWorking with dates 74 -- _rAssignment Statements 75 -- _rArrays 77 -- _rDeclaring arrays 77 -- _rDeclaring multidimensional arrays 78 -- _rDeclaring dynamic arrays 79 -- _rObject Variables 79 -- _rUser-Defined Data Types 80 -- _rBuilt-In Functions 81 -- _rManipulating Objects and Collections 84 -- _rWith-End With constructs 84 -- _rFor Each-Next constructs 85 -- _rControlling Code Execution 87 -- _rGoTo statements 88 -- _rIf-Then constructs 88 -- _rSelect Case constructs 93 -- _rLooping blocks of instructions 96 -- _rChapter 4: Working with VBA Sub Procedures 105 -- _rAbout Procedures 105 -- _rDeclaring a Sub procedure 106 -- _rScoping a procedure 107 -- _rExecuting Sub Procedures 108 -- _rExecuting a procedure with the Run Sub/UserForm command 109 -- _rExecuting a procedure from the Macro dialog box 109 -- _rExecuting a procedure with a Ctrl+shortcut key combination 110 -- _rExecuting a procedure from the Ribbon 111 -- _rExecuting a procedure from a customized shortcut menu 111 -- _rExecuting a procedure from another procedure 112 -- _rExecuting a procedure by clicking an object 116 -- _rExecuting a procedure when an event occurs 118 -- _rExecuting a procedure from the Immediate window 118 -- _rPassing Arguments to Procedures 119 -- _rError-Handling Techniques 123 -- _rTrapping errors 123 -- _rError-handling examples 124 -- _rA Realistic Example That Uses Sub Procedures 127 -- _rThe goal 128 -- _rProject requirements 128 -- _rWhat you know 128 -- _rThe approach 129 -- _rSome preliminary recording 129 -- _rInitial setup 131 -- _rCode writing 132 -- _rWriting the Sort procedure 133 -- _rMore testing 137 -- _rFixing the problems 138 -- _rUtility availability 141 -- _rEvaluating the project 142 -- _rChapter 5: Creating Function Procedures 143 -- _rSub Procedures versus Function Procedures 143 -- _rWhy Create Custom Functions? 144 -- _rAn Introductory Function Example 144 -- _rUsing the function in a worksheet 145 -- _rUsing the function in a VBA procedure 146 -- _rAnalyzing the custom function 146 -- _rFunction Procedures 148 -- _rA function's scope 150 -- _rExecuting function procedures 150 -- _rFunction Arguments 153 -- _rFunction Examples 153 -- _rFunctions with no argument 153 -- _rA function with one argument 156 -- _rA function with two arguments 159 -- _rA function with an array argument 159 -- _rA function with optional arguments 160 -- _rA function that returns a VBA array 162 -- _rA function that returns an error value 165 -- _rA function with an indefinite number of arguments 166 -- _rEmulating Excel's SUM Function 168 -- _rExtended Date Functions 171 -- _rDebugging Functions 173 -- _rDealing with the Insert Function Dialog Box 174 -- _rUsing the MacroOptions method 174 -- _rSpecifying a function category 176 -- _rAdding a function description manually 177 -- _rUsing Add-Ins to Store Custom Functions 178 -- _rUsing the Windows API 179 -- _rWindows API examples 179 -- _rDetermining the Windows directory 180 -- _rDetecting the Shift key 181 -- _rLearning more about API functions 182 -- _rChapter 6: Understanding Excel's Events 183 -- _rWhat You Should Know about Events 183 -- _rUnderstanding event sequences 184 -- _rWhere to put event-handler procedures 184 -- _rDisabling events 186 -- _rEntering event-handler code 187 -- _rEvent-handler procedures that use arguments 188 -- _rGetting Acquainted with Workbook-Level Events 190 -- _rThe Open event 191 -- _rThe Activate event 192 -- _rThe SheetActivate event 192 -- _rThe NewSheet event 193 -- _rThe BeforeSave event 193 -- _rThe Deactivate event 193 -- _rThe BeforePrint event 194 -- _rThe BeforeClose event 195 -- _rExamining Worksheet Events 197 -- _rThe Change event 198 -- _rMonitoring a specific range for changes 199 -- _rThe SelectionChange event 203 -- _rThe BeforeDoubleClick event 204 -- _rThe BeforeRightClick event 205 -- _rMonitoring with Application Events 206 -- _rEnabling Application-level events 207 -- _rDetermining when a workbook is opened 208 -- _rMonitoring Application-level events 209 -- _rAccessing Events Not Associated with an Object 210 -- _rThe OnTime event 210 -- _rThe OnKey event 212 -- _rChapter 7: VBA Programming Examples and Techniques 217 -- _rLearning by Example 217 -- _rWorking with Ranges 218 -- _rCopying a range 218 -- _rMoving a range 219 -- _rCopying a variably sized range 220 -- _rSelecting or otherwise identifying various types of ranges 221 -- _rResizing a range 223 -- _rPrompting for a cell value 224 -- _rEntering a value in the next empty cell 225 -- _rPausing a macro to get a user-selected range 226 -- _rCounting selected cells 228 -- _rDetermining the type of selected range 229 -- _rLooping through a selected range efficiently 231 -- _rDeleting all empty rows 233 -- _rDuplicating rows a variable number of times 234 -- _rDetermining whether a range is contained in another range 236 -- _rDetermining a cell's data type 237 -- _rReading and writing ranges 238 -- _rA better way to write to a range 240 -- _rTransferring one-dimensional arrays 242 -- _rTransferring a range to a variant array 242 -- _rSelecting cells by value 243 -- _rCopying a noncontiguous range 244 -- _rWorking with Workbooks and Sheets 246 -- _rSaving all workbooks 246 -- _rSaving and closing all workbooks 247 -- _rHiding all but the selection 247 -- _rCreating a hyperlink table of contents 249 -- _rSynchronizing worksheets 250 -- _rVBA Techniques 251 -- _rToggling a Boolean property 251 -- _rDisplaying the date and time 251 -- _rDisplaying friendly time 253 -- _rGetting a list of fonts 254 -- _rSorting an array 256 -- _rProcessing a series of files 257 -- _rSome Useful Functions for Use in Your Code 259 -- _rThe FileExists function 259 -- _rThe FileNameOnly function 259 -- _rThe PathExists function 260 -- _rThe RangeNameExists function 260 -- _rThe SheetExists function 261 -- _rThe WorkbookIsOpen function 261 -- _rRetrieving a value from a closed workbook 262 -- _rSome Useful Worksheet Functions 264 -- _rReturning cell formatting information 264 -- _rA talking worksheet 266 -- _rDisplaying the |
||
| 505 | _r | ||
| 505 |
_rdate when a file was saved or printed 266 -- _rUnderstanding object parents 267 -- _rCounting cells between two values 268 -- _rDetermining the last nonempty cell in a column or row 269 -- _rDoes a string match a pattern? 270 -- _rExtracting the nth element from a string 272 -- _rSpelling out a number 272 -- _rA multifunctional function 273 -- _rThe SHEETOFFSET function 274 -- _rReturning the maximum value across all worksheets 275 -- _rReturning an array of nonduplicated random -- |
||
| 505 | _r-- | ||
| 505 | _r-- | ||
| 505 |
_rintegers 276 -- _rRandomizing a range 278 -- _rSorting a range 279 -- _rWindows API Calls 280 -- _rUnderstanding API Declarations 280 -- _rDetermining file associations 281 -- _rDetermining default printer information 282 -- _rDetermining video display information 283 -- _rReading from and writing to the Registry 284 -- _rPart II: Advanced VBA Techniques -- _rChapter 8: Working with Pivot Tables 291 -- _rAn Introductory Pivot Table Example 291 -- _rCreating a pivot table 292 -- _rExamining the recorded code for the pivot table 294 -- _rCleaning up the recorded pivot table code 294 -- _rCreating a More Complex Pivot Table 297 -- _rThe code that created the pivot table 298 -- _rHow the more complex pivot table works 299 -- _rCreating Multiple Pivot Tables 301 -- _rCreating a Reverse Pivot Table304 -- _rChapter 9: Working with Charts 307 -- _rGetting the Inside Scoop on Charts 307 -- _rChart locations 307 -- _rThe macro recorder and charts 308 -- _rThe Chart object model 308 -- _rCreating an Embedded Chart 310 -- _rCreating a Chart on a Chart Sheet 311 -- _rModifying Charts 312 -- _rUsing VBA to Activate a Chart 313 -- _rMoving a Chart 314 -- _rUsing VBA to Deactivate a Chart 315 -- _rDetermining Whether a Chart Is Activated 316 -- _rDeleting from the ChartObjects or Charts Collection 316 -- _rLooping through All Charts 318 -- _rSizing and Aligning ChartObjects 320 -- _rCreating Lots of Charts 321 -- _rExporting a Chart 324 -- _rExporting all graphics 325 -- _rChanging the Data Used in a Chart 326 -- _rChanging chart data based on the active cell 327 -- _rUsing VBA to determine the ranges used in a chart 329 -- _rUsing VBA to Display Arbitrary Data Labels on a Chart 331 -- _rDisplaying a Chart in a UserForm 335 -- _rUnderstanding Chart Events 337 -- _rAn example of using Chart events 338 -- _rEnabling events for an embedded chart 340 -- _rExample: Using Chart events with an embedded chart 342 -- _rDiscovering VBA Charting Tricks 344 -- _rPrinting embedded charts on a full page 344 -- _rCreating unlinked charts 344 -- _rDisplaying text with the MouseOver event 346 -- _rScrolling a chart 349 -- _rWorking with Sparkline Charts 351 -- _rChapter 10: Interacting with Other Applications 355 -- _rUnderstanding Microsoft Office Automation 355 -- _rUnderstanding the concept of binding 356 -- _rA simple automation example 358 -- _rAutomating Access from Excel 359 -- _rRunning an Access Query from Excel 359 -- _rRunning an Access Macro from Excel 360 -- _rAutomating Word from Excel 361 -- _rSending Excel data to a Word document 361 -- _rSimulating mail merge with a Word document 362 -- _rAutomating PowerPoint from Excel 364 -- _rSending Excel data to a PowerPoint presentation 365 -- _rSending all Excel charts to a PowerPoint presentation 366 -- _rConvert a workbook into a PowerPoint presentation 367 -- _rAutomating Outlook from Excel 369 -- _rMailing the Active Workbook as an Attachment 369 -- _rMailing a Specific Range as an Attachment 370 -- _rMailing a Single Sheet as an Attachment 371 -- _rMailing All Email Addresses in Your Contact List 372 -- _rStarting Other Applications from Excel 373 -- _rUsing the VBA Shell function 373 -- _rUsing the Windows ShellExecute API function 376 -- _rUsing AppActivate 377 -- _rRunning Control Panel dialog boxes 378 -- _rChapter 11: Working with External Data and Files 379 -- _rWorking with External Data Connections 379 -- _rManually creating a connection 379 -- _rManually editing data connections 383 -- _rUsing VBA to create dynamic connections 384 -- _rIterating through all connections in a workbook 386 -- _rUsing ADO and VBA to Pull External Data 387 -- _rThe connection string 388 -- _rDeclaring a Recordset 389 -- _rReferencing the ADO object library 390 -- _rPutting it all together in code 391 -- _rUsing ADO with the active workbook 392 -- _rWorking with Text Files 394 -- _rOpening a text file 395 -- _rReading a text file 396 -- _rWriting a text file 396 -- _rGetting a file number 396 -- _rDetermining or setting the file position 397 -- _rStatements for reading and writing 397 -- _rText File Manipulation Examples 398 -- _rImporting data in a text file 398 -- _rExporting a range to a text file 398 -- _rImporting a text file to a range 399 -- _rLogging Excel usage 400 -- _rFiltering a text file 401 -- _rPerforming Common File Operations 402 -- _rUsing VBA file-related statements 402 -- _rUsing the FileSystemObject object 407 -- _rZipping and Unzipping Files 410 -- _rZipping files 410 -- _rUnzipping a file 411 -- _rPart III: Working with UserForms -- _rChapter 12: Leveraging Custom Dialog Boxes 415 -- _rBefore You Create That UserForm 415 -- _rUsing an Input Box 415 -- _rThe VBA InputBox function 416 -- _rThe Application.InputBox method 418 -- _rThe VBA MsgBox Function 421 -- _rThe Excel GetOpenFilename Method 426 -- _rThe Excel GetSaveAsFilename Method 429 -- _rPrompting for a Directory 430 -- _rDisplaying Excel's Built-In Dialog Boxes 430 -- _rDisplaying a Data Form 433 -- _rMaking the data form accessible 434 -- _rDisplaying a data form by using VBA 434 -- _rChapter 13: Introducing UserForms 435 -- _rHow Excel Handles Custom Dialog Boxes 435 -- _rInserting a New UserForm 436 -- _rAdding Controls to a UserForm 437 -- _rToolbox Controls 437 -- _rCheckBox 438 -- _rComboBox 438 -- _rCommandButton 438 -- _rFrame 439 -- _rImage 439 -- _rLabel 439 -- _rListBox 439 -- _rMultiPage 439 -- _rOptionButton 439 -- _rRefEdit 440 -- _rScrollBar 440 -- _rSpinButton 440 -- _rTabStrip 440 -- _rTextBox 440 -- _rToggleButton 440 -- _rAdjusting UserForm Controls 442 -- _rAdjusting a Control's Properties 443 -- _rUsing the Properties window 443 -- _rCommon properties 445 -- _rAccommodating keyboard users 447 -- _rDisplaying a UserForm 449 -- _rAdjusting the display position 449 -- _rDisplaying a modeless UserForm 450 -- _rDisplaying a UserForm based on a variable 450 -- _rLoading a UserForm 450 -- _rAbout event-handler procedures 451 -- _rClosing a UserForm 451 -- _rCreating a UserForm: An Example 453 -- _rCreating the UserForm 453 -- _rWriting code to display the dialog box 455 -- _rTesting the dialog box 456 -- _rAdding event-handler procedures 457 -- _rThe finished dialog box 459 -- _rUnderstanding UserForm Events 459 -- _rLearning about events 459 -- _rUserForm events 460 -- _rSpinButton events 461 -- _rPairing a SpinButton with a TextBox 462 -- _rReferencing UserForm Controls 465 -- _rCustomizing the Toolbox 466 -- _rAdding new pages to the Toolbox 467 -- _rCustomizing or combining controls 467 -- _rAdding new ActiveX controls 468 -- _rCreating UserForm Templates 469 -- _rA UserForm Checklist 469 -- _rChapter 14: UserForm Examples 471 -- _rCreating a UserForm 'Menu'471 -- _rUsing CommandButtons in a UserForm 471 -- _rUsing a ListBox in a UserForm 472 -- _rSelecting Ranges from a UserForm 474 -- _rCreating a Splash Screen 476 -- _rDisabling a UserForm's Close Button 478 -- _rChanging a UserForm's Size 479 -- _rZooming and Scrolling a Sheet from a UserForm 480 -- _rListBox Techniques 482 -- _rAdding items to a ListBox control 483 -- _rDetermining the selected item in a ListBox 487 -- _rDetermining multiple selections in a ListBox 488 -- _rMultiple lists in a single ListBox 489 -- _rListBox item transfer 490 -- _rMoving items in a ListBox 492 -- _rWorking with multicolumn ListBox controls 494 -- _rUsing a ListBox to select worksheet rows 496 -- _rUsing a ListBox to activate a sheet 498 -- _rFiltering a ListBox from a TextBox 501 -- _rUsing the MultiPage Control in a UserForm 503 -- _rUsing an External Control 504 -- _rAnimating a Label 506 -- _rChapter 15: Advanced UserForm Techniques 511 -- _rA Modeless Dialog Box 512 -- _rDisplaying a Progress Indicator 516 -- _rCreating a stand-alone progress indicator 517 -- _rShowing a progress indicator that's integrated into a UserForm 520 -- _rCreating a non-graphical progress indicator 524 -- _rCreating Wizards 527 -- _rSetting up the MultiPage control for the wizard 528 -- _rAdding the buttons to the wizard's UserForm 528 -- _rProgramming the wizard's buttons 528 -- _rProgramming dependencies in a wizard 530 -- _rPerforming the task with the wizard 532 -- _rEmulating the MsgBox Function 533 -- _rMsgBox emulation: MyMsgBox code 533 -- _rHow the MyMsgBox function works 535 -- _rUsing the MyMsgBox function 537 -- _rA UserForm with Movable Controls 537 -- _rA UserForm with No Title Bar 538 -- _rSimulating a Toolbar with a UserForm 540 -- _rEmulating a Task Pane with a UserForm 542 -- _rA Resizable UserForm 543 -- _rHandling Multiple UserForm Controls with One Event Handler 547 -- _rSelecting a Color in a UserForm 550 -- _rDisplaying a Chart in a UserForm 552 -- _rSaving a chart as a GIF file 553 |
||
| 505 |
_r-- _rChanging the Image control's Picture property 554 -- _rMaking a UserForm Semitransparent 554 -- _rA Puzzle on a UserForm 556 -- _rVideo Poker on a UserForm 557 -- _rPart IV: Developing Excel Applications -- _rChapter 16: Creating and Using Add-Ins 561 -- _rWhat Is an Add-In? 561 -- _rComparing an add-in with a standard workbook 561 -- _rWhy create add-ins? 562 -- _rUnderstanding Excel's Add-In Manager 564 -- _rCreating an Add-in 566 -- _rAn Add-In Example 567 -- _rAdding -- |
||
| 505 |
_rdescriptive information for the example add-in 568 -- _rCreating an add-in 568 -- _rInstalling an add-in 570 -- _rTesting the add-in 571 -- _rDistributing an add-in 571 -- _rModifying an add-in 571 -- _rComparing XLAM and XLSM Files 572 -- _rXLAM file VBA collection membership 573 -- _rVisibility of XLSM and XLAM files 573 -- _rWorksheets and chart sheets in XLSM and XLAM files 574 -- _rAccessing VBA procedures in an add-in 575 -- _rManipulating Add-Ins with VBA 578 -- _rAdding an item to the AddIns collection 579 -- _rRemoving an item from the AddIns collection 580 -- _rAddIn object properties 580 -- _rAccessing an add-in as a workbook 583 -- _rAddIn object events 584 -- _rOptimizing the Performance of Add-Ins 584 -- _rSpecial Problems with Add-Ins 585 -- _rEnsuring that an add-in is installed 585 -- _rReferencing other files from an add-in 587 -- _rDetecting the proper Excel version for your add-in 588 -- _rChapter 17: Working with the Ribbon 589 -- _rRibbon Basics 589 -- _rCustomizing the Ribbon 591 -- _rAdding a button to the Ribbon 591 -- _rAdding a button to the Quick Access Toolbar 594 -- _rUnderstanding the limitations of Ribbon customization 595 -- _rCreating a Custom Ribbon 596 -- _rAdding a button to an existing tab 596 -- _rAdding a check box to an existing tab 602 -- _rRibbon controls demo 605 -- _rA dynamicMenu control example 613 -- _rMore on Ribbon customization 616 -- _rUsing VBA with the Ribbon 617 -- _rAccessing a Ribbon control 617 -- _rWorking with the Ribbon 619 -- _rActivating a tab 621 -- _rCreating an Old-Style Toolbar 621 -- _rLimitations of old-style toolbars in Excel 2007 and later 622 -- _rCode to create a toolbar 622 -- _rChapter 18: Working with Shortcut Menus 625 -- _rCommandBar Overview 625 -- _rCommandBar types 626 -- _rListing shortcut menus 626 -- _rReferring to CommandBars 627 -- _rReferring to controls in a CommandBar 628 -- _rProperties of CommandBar controls 630 -- _rDisplaying all shortcut menu items 630 -- _rUsing VBA to Customize Shortcut Menus 632 -- _rShortcut menu and the single-document interface 633 -- _rResetting a shortcut menu634 -- _rDisabling a shortcut menu636 -- _rDisabling shortcut menu items 636 -- _rAdding a new item to the Cell shortcut menu 637 -- _rAdding a submenu to a shortcut menu 639 -- _rLimiting a shortcut menu to a single workbook642 -- _rShortcut Menus and Events 642 -- _rAdding and deleting menus automatically 642 -- _rDisabling or hiding shortcut menu items 643 -- _rCreating a context-sensitive shortcut menu 643 -- _rChapter 19: Providing Help for Your Applications 647 -- _rHelp for Your Excel Applications 647 -- _rHelp Systems That Use Excel Components 649 -- _rUsing cell comments for help 649 -- _rUsing a text box for help650 -- _rUsing a worksheet to display help text 652 -- _rDisplaying help in a UserForm 653 -- _rDisplaying Help in a Web Browser 657 -- _rUsing HTML files 657 -- _rUsing an MHTML file 658 -- _rUsing the HTML Help System 659 -- _rUsing the Help method to display HTML Help 662 -- _rAssociating a help file with your application 663 -- _rAssociating a help topic with a VBA function 663 -- _rChapter 20: Leveraging Class Modules 665 -- _rWhat Is a Class Module? 665 -- _rBuilt-in class modules666 -- _rCustom class modules 666 -- _rCreating a NumLock Class 667 -- _rInserting a class module 668 -- _rAdding VBA code to the class module 668 -- _rUsing the CNumLock class 670 -- _rCoding Properties, Methods, and Events 671 -- _rProgramming properties of objects 671 -- _rProgramming methods for objects 673 -- _rClass module events 673 -- _rExposing a QueryTable Event 674 -- _rCreating a Class to Hold Classes 677 -- _rCreating the CSalesRep and CSalesReps classes 677 -- _rCreating the CInvoice and CInvoices classes 679 -- _rFilling the parent classes with objects 680 -- _rCalculating the commissons 682 -- _rChapter 21: Understanding Compatibility Issues 685 -- _rWhat Is Compatibility? 685 -- _rTypes of Compatibility Problems 686 -- _rAvoid Using New Features 687 -- _rBut Will It Work on a Mac? 689 -- _rDealing with 64-Bit Excel 690 -- _rCreating an International Application 691 -- _rMultilanguage applications 693 -- _rVBA language considerations 694 -- _rUsing local properties 694 -- _rIdentifying system settings 695 -- _rDate and time settings 697 -- _rPart V: Appendix -- _rAppendix A: VBA Statements and Function Reference 701 -- _rIndex 709-- |
||
| 520 | _aMaximize your Excel experience with VBA ; Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website. ; Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce-and can help you take your career to the next level. ; Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques ; Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text ; Access online resources, including the Power Utility Pak, that supplement the content ; Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office ; Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA. | ||
| 630 |
_aHF COMMERCE _914 |
||
| 650 |
_aMicrosoft Excel (Computer file) _9898 |
||
| 650 |
_aVisual Basic for Applications program language) _98139 |
||
| 650 |
_aVisual programming science) _99374 |
||
| 650 |
_aBusiness _xComputer programs _99372 |
||
| 650 |
_aElectronic spreadsheets _93043 |
||
| 650 |
_aBusiness _xComputer spreadsheets _99375 |
||
| 650 |
_aVisual science) _99376 |
||
| 650 |
_aEXCEL 2016 _99377 |
||
| 650 |
_aVisual BASIC _99378 |
||
| 650 |
_a _912 |
||
| 700 |
_aKusleika, Dick, _eAuthor |
||
| 700 |
_aAlexander, Michael, _eAuthor |
||
| 856 | _uhttps://books.google.es/books?id=6ftcCgAAQBAJ&printsec=frontcover&dq=excel+2016+power+programming+with+vba&hl=ca&sa=X&ved=0ahUKEwiVjtDW34LZAhXMuRQKHb8KArIQ6AEIJzAA#v=onepage&q=excel%202016%20power%20programming%20with%20vba&f=false | ||
| 902 | _a660 | ||
| 905 | _am | ||
| 912 | _a2016-01-01 | ||
| 942 | _a1 | ||
| 953 | _d2018-01-31 18:42:11 | ||
| 999 |
_c1942 _d1942 |
||