Microsoft Excel 2016 Programming by Example : With VBA, XML, and ASP

A practical, how-to book on Excel programming, suitable for readers already familiar with the Excel user interface, this book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. --

Saved in:
Bibliographic Details
Main Author: Korol, Julitta, (Author)
Format: eBook
Language: English
Published: Dulles, Virginia : Mercury Learning and Information, 2017.
Subjects:
Microsoft Excel (Computer file)
Electronic spreadsheets.
Visual programming (Computer science)
elektronické knihy
electronic books
ISBN: 9781944534516
1944534512
9781523112609
1523112603
1942270852
9781942270850
Physical Description: 1 online resource

Cover

Table of contents

LEADER 11780cam a2200493 i 4500
001 kn-ocn966373813
003 OCoLC
005 20240717213016.0
006 m o d
007 cr cn|||||||||
008 161204s2017 vaua ob 000 0 eng d
040 |a COO  |b eng  |e rda  |e pn  |c COO  |d OCLCO  |d UAB  |d OCLCF  |d K6U  |d OTZ  |d LIV  |d MERER  |d OCLCQ  |d KNOVL  |d D6H  |d ERL  |d VVB  |d OCLCQ  |d CEF  |d OCLCQ  |d COO  |d STF  |d ZCU  |d TEFOD  |d LVT  |d AU@  |d OCLCQ  |d OCLCO  |d BRF  |d UX1  |d VT2  |d OCLCO  |d OCLCQ  |d COA  |d INARC  |d OCLCO  |d OCLCL  |d SFB 
020 |a 9781944534516  |q (electronic bk.) 
020 |a 1944534512  |q (electronic bk.) 
020 |a 9781523112609  |q (electronic bk.) 
020 |a 1523112603  |q (electronic bk.) 
020 |z 1942270852 
020 |z 9781942270850 
024 8 |a (WaSeSS)ssj0002056933 
035 |a (OCoLC)966373813  |z (OCoLC)962060702  |z (OCoLC)1260324628  |z (OCoLC)1262677637  |z (OCoLC)1340086216  |z (OCoLC)1392380123 
100 1 |a Korol, Julitta,  |e author. 
245 1 0 |a Microsoft Excel 2016 Programming by Example :  |b With VBA, XML, and ASP /  |c Julitta Korol. 
264 1 |a Dulles, Virginia :  |b Mercury Learning and Information,  |c 2017. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
506 |a Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty 
520 |a A practical, how-to book on Excel programming, suitable for readers already familiar with the Excel user interface, this book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. --  |c Edited summary from book. 
504 |a Includes bibliographical references. 
505 0 |a Cover -- Title Page -- Copyright -- Contents -- Acknowledgments -- Introduction -- Part I Excel VBA Primer -- Chapter 1 Excel Macros -- A Quick Start in Excel VBA Programming -- Macros and VBA -- Excel Macro-Enabled File Formats -- Macro Security Settings -- Enabling the Developer Tab in Excel -- Hands-On 1.1. Setting Up Excel for Macro Development -- Using The Built-In Macro Recorder -- Planning a Macro -- Hands-On 1.2. Getting Things Ready for Macro Recording -- Recording a Macro -- Hands-On 1.3. Inserting and Naming a Worksheet (Macro Task 1) -- Hands-On 1.4. Inserting Column Headings and Applying Formatting (Macro Task 2) -- Hands-On 1.5. Entering Employee Data (Macro Task 3) -- Hands-On 1.6. Entering Formulas to Fill in Employee First Name (Macro Task 4) -- Hands-On 1.7. Entering Formulas to Fill in Employee Last Name (Macro Task 5) -- Hands-On 1.8. Entering Formulas to Calculate Employee Total Wages (Macro Task 6) -- Hands-On 1.9. Applying Table Format (Macro Task 7) -- Editing Recorded Macros -- Hands-On 1.10. Examining the Macro Code -- Macro Comments -- Hands-On 1.11. Adding Comments to the Macro Code -- Cleaning Up the Macro Code -- Hands-On 1.12. Cleaning Up the Macro Code -- Running a Macro -- Hands-On 1.13. Running a Macro Using the Macro Dialog Box -- Testing and Debugging a Macro -- Hands-On 1.14. Running a Macro from the VBE Screen -- Saving and Renaming a Macro -- Hands-On 1.15. Saving Macros and Running Macros from Another Workbook -- Printing Macro Code -- Hands-On 1.16. Printing Macro Code -- Improving Your Recorded Macros -- Hands-On 1.17. Adding Visual Basic Statements to the Recorded Macro Code -- Creating a Master Macro -- Hands-On 1.18. Creating a Master Macro Procedure -- Various Methods Of Running Macros -- Running the Macro Using a Keyboard Shortcut -- Hands-On 1.19. Assigning a Macro to a Keyboard shortcut. 
505 8 |a Running the Macro from the Quick Access Toolbar -- Hands-On 1.20. Running a Macro from the Quick Access Toolbar -- Running the Macro from a Worksheet Button -- Hands-On 1.21. Running a Macro from a Button Placed on a Worksheet -- Summary -- Chapter 2 Excel Programming Environment -- A Quick Overview of Its Tools and Features -- Understanding the Project Explorer Window -- Understanding the Properties Window -- Understanding the Code Window -- Setting the VBE Options -- Syntax and Programming Assistance -- List Properties/Methods -- List Constants -- Parameter Info -- Quick Info -- Complete Word -- Indent/Outdent -- Hands-On 2.1. Indenting/Outdenting Visual Basic Code -- Comment Block/Uncomment Block -- Using The Object Browser -- Hands-On 2.2. Writing a VBA Procedure to Move a Text Box on the Worksheet -- Hands-On 2.3. Writing a VBA Procedure to Move a Circle on the Worksheet -- Locating Procedures with the Object Browser -- Hands-On 2.4. Using Object Browser to Locate VBA Procedures -- Using the VBA Object Library -- Hands-On 2.5. Writing a VBA Procedure to Create a Folder in Windows -- Using the Immediate Window -- Hands-On 2.6. Entering and Executing VBA Statements in the Immediate Window -- Obtaining Information in the Immediate Window -- Hands-On 2.7. Obtaining Information in the Immediate Window -- Working with Worksheet Cells and Ranges -- Using the Range Property -- Hands-On 2.8. Practice Using the Range Property to Select Worksheet Cells -- Using the Cells Property -- Hands-On 2.9. Practice Using the Cells Property to Select Worksheet Cells (Part I) -- Hands-On 2.10. Practice Using the Cells Property to Select Worksheet Cells (Part II) -- Using the Offset Property -- Hands-On 2.11. Selecting Cells Using the Offset Property -- Using the Resize Property -- Hands-On 2.12. Writing a VBA Statement to Resize a Selection of Cells. 
505 8 |a Using the End Property -- Hands-On 2.13. Selecting Cells Using the End Property -- Moving, Copying, and Deleting Cells -- Hands-On 2.14. Moving, Copying, and Deleting Cells -- Working with Rows and Columns -- Hands-On 2.15. Selecting Entire Rows and Columns -- Obtaining Information about the Worksheet -- Hands-On 2.16. Counting Rows and Columns -- Entering Data and Formatting Cells -- Hands-On 2.17. Using VBA Statements to Enter Data in a Worksheet -- Returning Information Entered in a Worksheet -- Finding Out about Cell Formatting -- Working with Workbooks and Worksheets -- Hands-On 2.18. Working with Workbooks -- Hands-On 2.19. Working with Worksheets -- Working with Windows -- Hands-On 2.20. Working with Windows -- Working with the Excel Application -- Hands-On 2.21. Working with the Excel Application -- Summary -- Chapter 3 Excel VBA Fundamentals -- A Quick Reference to Writing VBA Code -- Excel Objects,Properties, and Methods -- Microsoft Excel Object Model -- Writing Simple and Complex VBA Statements -- Breaking Up Long VBA Statements -- Saving Results of VBA Statements -- Introducing Data Types -- Using Variables -- How to Create Variables -- How to Declare Variables -- Specifying the Data Type of a Variable -- Assigning Values to Variables -- Hands-On 3.1. Writing a VBA Procedure with Variables -- Forcing Declaration of Variables -- Hands-On 3.2. Writing a VBA Procedure with Explicitly Declared Variables -- Understanding the Scope of Variables -- Procedure-Level (Local) Variables -- Module-Level Variables -- Hands-On 3.3. Writing a VBA Procedure with a Module-Level Variable -- Project-Level Variables -- Lifetime of Variables -- Finding a Variable Definition -- Determining a Data Type of a Variable -- Hands-On 3.4. Using the Built-In VarType Function -- Using Constants -- Built-In Constants. 
505 8 |a Hands-On 3.5. Viewing Excel Constants in the Object Browser -- Converting between Data Types -- Hands-On 3.6. Using Data Type Conversion Functions in VBA -- Hands-On 3.7. Writing a VBA Procedure with a Static Variable -- Using Object Variables in VBA Procedures -- Hands-On 3.8. Writing a VBA Procedure with Object Variables -- Using Specific Object Variables -- Summary -- Chapter 4 Excel VBA Procedures -- A Quick Guide to Writing Function Procedures -- Understanding Function Procedures -- Creating a Function Procedure -- Hands-On 4.1. Writing a Simple Function Procedure -- Various Methods of Running Function Procedures -- Running a Function Procedure from a Worksheet -- Hands-On 4.2. Executing a Function Procedure from within an Excel Worksheet -- Running a Function Procedure from Another VBA Procedure -- Hands-On 4.3. Executing a Function from a VBA Procedure -- Ensuring Availability of Your Custom Functions -- Passing Arguments to Function Procedures -- Hands-On 4.4. Passing Arguments to Functions (Example 1) -- Specifying Argument Types -- Hands-On 4.5. Passing Arguments to Functions (Example 2) -- Passing Arguments by Reference and Value -- Hands-On 4.6. Passing Arguments to Functions (Example 3) -- Using Optional Arguments -- Hands-On 4.7. Writing Functions with Optional Arguments -- Testing a Function Procedure -- Locating Built-In Functions -- Getting to Know the MsgBox Function -- Hands-On 4.8. Formatting Text for Display in the MsgBox Function -- Hands-On 4.9. Using the MsgBox Function with Arguments (Example 1) -- Hands-On 4.10. Using the MsgBox Function with Arguments (Example 2) -- Returning Values from the MsgBox Function -- Hands-On 4.11. Using the MsgBox Function with Arguments (Example 3) -- Getting to Know the InputBox Function -- Hands-On 4.12. Using the InputBox Function (Example 1) -- Determining and Converting Data Types. 
505 8 |a Hands-On 4.13. Using the InputBox Function (Example 2) -- Using the InputBox Method -- Hands-On 4.14. Using the Excel InputBox Method -- Summary -- Chapter 5 Adding Decisions to Excel VBA Programs -- A Quick Introduction to Conditional Statements -- Relational and Logical Operators -- Using If...Then Statement -- Hands-On 5.1. Evaluating Conditions in the Immediate Window -- Hands-On 5.2. Writing a VBA Procedure with a Simple If...Then Statement -- Using If...Then...Else Statement -- Hands-On 5.3. Writing a VBA Procedure with an If Then...Else Statement -- Using If...Then...ElseIf Statement -- Hands-On 5.4. Writing a VBA Procedure with an If...Then...ElseIf Statement -- Nested If...Then Statements -- Using the Select Case Statement -- Hands-On 5.5. Writing a VBA Procedure with a Select Case Statement -- Using Is with the Case Clause -- Specifying a Range of Values in a Case Clause -- Specifying Multiple Expressions in a Case Clause -- Writing a VBA Procedure with Multiple Conditions -- Hands-On 5.6. Writing a VBA Procedure with Multiple Conditions -- Using Conditional Logic in Function Procedures -- Hands-On 5.7. Writing a Function Procedure with a Select Case Statement -- Summary -- Chapter 6 Adding Repeating Actions to Excel VBA Programs -- A Quick Introduction to Looping Statements -- Introducing Looping Statements -- Understanding Do...While and Do...Until Loops -- Hands-On 6.1. Writing a VBA Procedure with a Do... While Statement -- Hands-On 6.2. Writing a VBA Procedure with a Do... Until Statement -- Avoiding Infinite Loops -- Executing a Procedure Line by Line -- Hands-On 6.3. Executing a Procedure Line by Line -- Understanding While...Wend Loop -- Hands-On 6.4. Writing a VBA Procedure with a While... Wend Statement -- Understanding For...Next Loop -- Hands-On 6.5. Writing a VBA Procedure with a For... Next Statement -- Understanding For...Each...Next Loop. 
590 |a Knovel  |b Knovel (All titles) 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Electronic spreadsheets. 
650 0 |a Visual programming (Computer science) 
655 7 |a elektronické knihy  |7 fd186907  |2 czenas 
655 9 |a electronic books  |2 eczenas 
776 0 8 |i Print version:  |a Korol, Julitta.  |t Microsoft Excel 2016 Programming by Example.  |d Dulles, Virginia : Mercury Learning and Information, 2017  |w (DLC) 2016940551 
856 4 0 |u https://proxy.k.utb.cz/login?url=https://app.knovel.com/hotlink/toc/id:kpMEPEVBAB/microsoft-excel-2016?kpromoter=marc  |y Full text 

Similar Items