Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Mastering VBA for Microsoft Office 2007 [[electronic resource] /] / Richard Mansfield
| Mastering VBA for Microsoft Office 2007 [[electronic resource] /] / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., c2008 |
| Descrizione fisica | 1 online resource (890 p.) |
| Disciplina |
005.13/3
005.5 |
| Collana | Sybex serious skills |
| Soggetto topico | Business - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-38212-4
9786611382124 0-470-37845-X |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Mastering VBA for Microsoft Office 2007; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Microsoft Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel Macro; Assigning a Way of Running the Macro; Deleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor
Using the Visual Basic Editor's Main WindowsSetting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom Line; Chapter 4: Creating Code from Scratch in the Visual Basic Editor; Setting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel Creating a Procedure for PowerPointCreating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work With VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom Line; Chapter 6: Working with Variables, Constants, and Enumerations; Working with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array Storing Values in an ArrayMultidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching Through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need; What Is an Object?; Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Functions What Is a Function?Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function; Examples of Functions for Any VBA-Enabled Application; Creating a Function for Word; Creating a Function for Excel; Creating a Function for PowerPoint; Creating a Function for Access; The Bottom Line; Chapter 11: Making Decisions in Your Code How Do You Compare Things in VBA? |
| Record Nr. | UNINA-9910454178703321 |
Mansfield Richard <1945->
|
||
| Indianapolis, Ind., : Wiley Pub., c2008 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Microsoft Office 2007 [[electronic resource] /] / Richard Mansfield
| Mastering VBA for Microsoft Office 2007 [[electronic resource] /] / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., c2008 |
| Descrizione fisica | 1 online resource (890 p.) |
| Disciplina |
005.13/3
005.5 |
| Collana | Sybex serious skills |
| Soggetto topico | Business - Computer programs |
| ISBN |
1-281-38212-4
9786611382124 0-470-37845-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Mastering VBA for Microsoft Office 2007; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Microsoft Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel Macro; Assigning a Way of Running the Macro; Deleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor
Using the Visual Basic Editor's Main WindowsSetting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom Line; Chapter 4: Creating Code from Scratch in the Visual Basic Editor; Setting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel Creating a Procedure for PowerPointCreating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work With VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom Line; Chapter 6: Working with Variables, Constants, and Enumerations; Working with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array Storing Values in an ArrayMultidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching Through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need; What Is an Object?; Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Functions What Is a Function?Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function; Examples of Functions for Any VBA-Enabled Application; Creating a Function for Word; Creating a Function for Excel; Creating a Function for PowerPoint; Creating a Function for Access; The Bottom Line; Chapter 11: Making Decisions in Your Code How Do You Compare Things in VBA? |
| Record Nr. | UNINA-9910782154203321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, Ind., : Wiley Pub., c2008 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Microsoft Office 2007 / / Richard Mansfield
| Mastering VBA for Microsoft Office 2007 / / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., c2008 |
| Descrizione fisica | 1 online resource (890 p.) |
| Disciplina |
005.13/3
005.5 |
| Collana | Sybex serious skills |
| Soggetto topico | Business - Computer programs |
| ISBN |
1-281-38212-4
9786611382124 0-470-37845-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Mastering VBA for Microsoft Office 2007; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Microsoft Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel Macro; Assigning a Way of Running the Macro; Deleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor
Using the Visual Basic Editor's Main WindowsSetting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom Line; Chapter 4: Creating Code from Scratch in the Visual Basic Editor; Setting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel Creating a Procedure for PowerPointCreating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work With VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom Line; Chapter 6: Working with Variables, Constants, and Enumerations; Working with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array Storing Values in an ArrayMultidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching Through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need; What Is an Object?; Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Functions What Is a Function?Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function; Examples of Functions for Any VBA-Enabled Application; Creating a Function for Word; Creating a Function for Excel; Creating a Function for PowerPoint; Creating a Function for Access; The Bottom Line; Chapter 11: Making Decisions in Your Code How Do You Compare Things in VBA? |
| Record Nr. | UNINA-9910816030603321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, Ind., : Wiley Pub., c2008 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Microsoft Office 2016 / / Richard Mansfield
| Mastering VBA for Microsoft Office 2016 / / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [3rd ed.] |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Sybex, a Wiley brand, , [2016] |
| Descrizione fisica | 1 online resource (987 p.) |
| Disciplina | 005.2768 |
| Soggetto topico |
Integrated software
Business - Computer programs |
| ISBN |
1-119-22540-X
1-119-22539-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover ; Title Page ; Copyright ; Contents ; Introduction; Part 1 Recording Macros and Getting Started with VBA ; Chapter 1 Recording and Running Macros in the Office Applications ; What Is VBA and What Can You Do with It?
The Difference Between Visual Basic and Visual Basic for Applications Understanding Macro Basics ; Recording a Macro ; Displaying the Developer Tab on the Ribbon ; Planning the Macro ; Starting the Macro Recorder ; Naming the Macro ; Choosing How to Run a New Macro ; Running a Macro Recording a Sample Word Macro Recording a Sample Excel Macro ; Creating a Personal Macro Workbook ; Recording the Macro ; Specifying How to Trigger an Existing Macro ; Assigning a Macro to a Quick Access Toolbar Button in Word ; Assigning a Macro to a Shortcut Key Combination Deleting a Macro The Bottom Line ; Chapter 2 Getting Started with the Visual Basic Editor ; Opening the Visual Basic Editor ; Opening the Visual Basic Editor with a Macro Selected ; Opening the Visual Basic Editor Directly ; Navigating to a Macro Using the Visual Basic Editor's Main Windows The Project Explorer ; The Object Browser ; The Code Window ; The Properties Window ; The Immediate Window ; Setting Properties for a Project ; Customizing the Visual Basic Editor ; Choosing Editor and View Preferences Choosing and Laying Out the Editor Windows |
| Record Nr. | UNINA-9910798172303321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, Indiana : , : Sybex, a Wiley brand, , [2016] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Microsoft Office 2016 / / Richard Mansfield
| Mastering VBA for Microsoft Office 2016 / / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [3rd ed.] |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Sybex, a Wiley brand, , [2016] |
| Descrizione fisica | 1 online resource (987 p.) |
| Disciplina | 005.2768 |
| Soggetto topico |
Integrated software
Business - Computer programs |
| ISBN |
1-119-22540-X
1-119-22539-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover ; Title Page ; Copyright ; Contents ; Introduction; Part 1 Recording Macros and Getting Started with VBA ; Chapter 1 Recording and Running Macros in the Office Applications ; What Is VBA and What Can You Do with It?
The Difference Between Visual Basic and Visual Basic for Applications Understanding Macro Basics ; Recording a Macro ; Displaying the Developer Tab on the Ribbon ; Planning the Macro ; Starting the Macro Recorder ; Naming the Macro ; Choosing How to Run a New Macro ; Running a Macro Recording a Sample Word Macro Recording a Sample Excel Macro ; Creating a Personal Macro Workbook ; Recording the Macro ; Specifying How to Trigger an Existing Macro ; Assigning a Macro to a Quick Access Toolbar Button in Word ; Assigning a Macro to a Shortcut Key Combination Deleting a Macro The Bottom Line ; Chapter 2 Getting Started with the Visual Basic Editor ; Opening the Visual Basic Editor ; Opening the Visual Basic Editor with a Macro Selected ; Opening the Visual Basic Editor Directly ; Navigating to a Macro Using the Visual Basic Editor's Main Windows The Project Explorer ; The Object Browser ; The Code Window ; The Properties Window ; The Immediate Window ; Setting Properties for a Project ; Customizing the Visual Basic Editor ; Choosing Editor and View Preferences Choosing and Laying Out the Editor Windows |
| Record Nr. | UNINA-9910816349903321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, Indiana : , : Sybex, a Wiley brand, , [2016] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Office 2010 [[electronic resource] /] / Richard Mansfield
| Mastering VBA for Office 2010 [[electronic resource] /] / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Publishing, Inc., 2010 |
| Descrizione fisica | 1 online resource (915 p.) |
| Disciplina | 005.2/768 |
| Collana | Sybex serious skills |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-282-77371-2
9786612773716 0-470-92263-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
MASTERING VBA for Microsoft® Office 2010; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Where to Get the Example Code; What Can I Do with VBA?; What's in This Book?; How Should I Use This Book?; Is This Book Suitable for Me?; Conventions Used in This Book; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel Macro
Assigning a Way of Running the MacroDeleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor; Using the Visual Basic Editor's Main Windows; Setting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom Line Chapter 4: Creating Code from Scratch in the Visual Basic EditorSetting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel; Creating a Procedure for PowerPoint; Creating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work with VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom Line Chapter 6: Working with Variables, Constants, and EnumerationsWorking with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array; Storing Values in an Array; Multidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need What Is an Object?Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Built-in Functions; What Is a Function?; Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function Examples of Functions for Any VBA-Enabled Application |
| Record Nr. | UNINA-9910459880703321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, IN, : Wiley Publishing, Inc., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Office 2010 [[electronic resource] /] / Richard Mansfield
| Mastering VBA for Office 2010 [[electronic resource] /] / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Publishing, Inc., 2010 |
| Descrizione fisica | 1 online resource (915 p.) |
| Disciplina | 005.2/768 |
| Collana | Sybex serious skills |
| ISBN |
1-282-77371-2
9786612773716 0-470-92263-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
MASTERING VBA for Microsoft® Office 2010; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Where to Get the Example Code; What Can I Do with VBA?; What's in This Book?; How Should I Use This Book?; Is This Book Suitable for Me?; Conventions Used in This Book; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel Macro
Assigning a Way of Running the MacroDeleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor; Using the Visual Basic Editor's Main Windows; Setting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom Line Chapter 4: Creating Code from Scratch in the Visual Basic EditorSetting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel; Creating a Procedure for PowerPoint; Creating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work with VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom Line Chapter 6: Working with Variables, Constants, and EnumerationsWorking with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array; Storing Values in an Array; Multidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need What Is an Object?Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Built-in Functions; What Is a Function?; Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function Examples of Functions for Any VBA-Enabled Application |
| Record Nr. | UNINA-9910785162203321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, IN, : Wiley Publishing, Inc., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering VBA for Office 2010 / / Richard Mansfield
| Mastering VBA for Office 2010 / / Richard Mansfield |
| Autore | Mansfield Richard <1945-> |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Publishing, Inc., 2010 |
| Descrizione fisica | 1 online resource (915 p.) |
| Disciplina | 005.2/768 |
| Collana | Sybex serious skills |
| ISBN |
1-282-77371-2
9786612773716 0-470-92263-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
MASTERING VBA for Microsoft® Office 2010; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Where to Get the Example Code; What Can I Do with VBA?; What's in This Book?; How Should I Use This Book?; Is This Book Suitable for Me?; Conventions Used in This Book; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel Macro
Assigning a Way of Running the MacroDeleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor; Using the Visual Basic Editor's Main Windows; Setting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom Line Chapter 4: Creating Code from Scratch in the Visual Basic EditorSetting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel; Creating a Procedure for PowerPoint; Creating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work with VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom Line Chapter 6: Working with Variables, Constants, and EnumerationsWorking with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array; Storing Values in an Array; Multidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need What Is an Object?Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Built-in Functions; What Is a Function?; Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function Examples of Functions for Any VBA-Enabled Application |
| Record Nr. | UNINA-9910828742903321 |
|
Mansfield Richard <1945->
|
||
| Indianapolis, IN, : Wiley Publishing, Inc., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||