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.
Excel programming weekend crash course / / Peter G. Aitken
| Excel programming weekend crash course / / Peter G. Aitken |
| Autore | Aitken Peter G |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2003 |
| Descrizione fisica | 1 online resource (457 p.) |
| Disciplina | 005.54 |
| Collana | Weekend Crash Course |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets Computer software - Programming |
| ISBN |
1-280-35369-4
9786610353699 0-7645-5575-8 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Excel Programming Weekend Crash Course; About the Author; Preface; Who Should Read This Book; Weekend Crash Course Layout and Features; Acknowledgments; Contents at a Glance; Contents; P A R T I: Friday Evening; Session 1: Microsoft Excel Programming - Why and How; Advantages of Programming; Programming Fundamentals; The VBA Language; The Excel Object Model; Objects and Classes; Macros and Programming; Designing Your Custom Application; Your First Excel Program; Programs and Procedures; Running the Program; Session 2: The VBA Code Editor; Code and Project Organization; Editing Tools
The Property WindowThe VBA Editor Menus; The Immediate Window; Using Macros in Programming; Session 3: The Excel Object Model; Understanding Properties and Methods; The Importance of Object References; Working with Collections; The Object Hierarchy; The Workbook Object; The Worksheet Object; The Usefulness of Nothing; Session 4: Syntax and Data in VBA; VBA Syntax Fundamentals; Employing Constants; Declaring and Using Variables; VBA Naming Rules; Variable Declaration and Option Explicit; Using Arrays; Determining Array Size; Understanding Variable Scope; P A R T I: Friday Evening Part Review P A R T II: Saturday MorningSession 5: Operators; The Assignment Operator; Numerical Operators; String Operators; Logical Operators; Comparison Operators; Operator Precedence; Session 6: Control Constructs; The If... Then Statement; With... End With; The Select Case Statement; The IIf Function; The Do... Loop Statement; The For... Next Statement; Stopping an Infinite Loop; The For Each... Next Statement; The Goto Statement; Session 7: Procedures and Modules; Sub Procedures; The Insert; Procedure Command; Function Procedures; Variables in Procedures; Procedure Scope; Storing Procedures Session 8: Working with Dates and TimesThe Date Data Type; Date/Time Values; Dates and System Settings; Date Calculations; The System Date and Time; Date and Time Details; Formatting Date/Time Values; Session 9: Working with Text; Text Input and Output; Searching for Text; Comparing Strings; String Conversions; Working with ASCII Values; Displaying Unicode Characters; Extracting or Modifying Parts of Strings; Session 10: Using Ranges and Selections; The Range Object; Empty Cells; Reading Data from Ranges; Naming Ranges; The Selection Property; Display a Range to the User P A R T II: Saturday Morning Part ReviewP A R T III: Saturday Afternoon; Session 11: Working with Columns, Rows, and Cells; Referencing Cells with the Cells Property; The SpecialCells Method; Screen Updating; Manipulating Columns and Rows; Referencing Entire Rows and Columns; Adding and Deleting Rows and Columns; Session 12: Programming with Custom Formulas; Cell References in Formulas; Use Caution When Using Links Between Workbooks; Operators; Avoiding Circular References; Controlling Formula Calculation; Session 13: Programming with Excel's Built-In Functions; Excel's Built-in Functions Using Excel Functions in Formulas |
| Record Nr. | UNINA-9910555227103321 |
Aitken Peter G
|
||
| Indianapolis, IN, : Wiley Pub., c2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Visual Basic .Net programming [[electronic resource] /] : Peter Aitken
| Visual Basic .Net programming [[electronic resource] /] : Peter Aitken |
| Autore | Aitken Peter G |
| Pubbl/distr/stampa | Scottsdale, Ariz., : Coriolis Group Books |
| Disciplina | 005.2/768 |
| Altri autori (Persone) | AitkenPeter G |
| Soggetto topico | BASIC (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910455466103321 |
|
Aitken Peter G
|
||
| Scottsdale, Ariz., : Coriolis Group Books | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Visual Basic .Net programming [[electronic resource] /] : Peter Aitken
| Visual Basic .Net programming [[electronic resource] /] : Peter Aitken |
| Autore | Aitken Peter G |
| Pubbl/distr/stampa | Scottsdale, Ariz., : Coriolis Group Books |
| Disciplina | 005.2/768 |
| Altri autori (Persone) | AitkenPeter G |
| Soggetto topico | BASIC (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910780119803321 |
|
Aitken Peter G
|
||
| Scottsdale, Ariz., : Coriolis Group Books | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Visual Basic .Net programming [[electronic resource] /] : Peter Aitken
| Visual Basic .Net programming [[electronic resource] /] : Peter Aitken |
| Autore | Aitken Peter G |
| Pubbl/distr/stampa | Scottsdale, Ariz., : Coriolis Group Books |
| Descrizione fisica | 1 online resource (648 pages) |
| Disciplina | 005.2/768 |
| Altri autori (Persone) | AitkenPeter G |
| Soggetto topico | BASIC (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Intro -- About the Author -- Acknowledgments -- Contents at a Glance -- Table of Contents -- Introduction -- Introduction to Visual Basic -- Using Visual Studio -- Visual Basic Syntax: Fundamentals and Data Storage -- Visual Basic Syntax: Program Control and Procedures -- Runtime Error and Exception Handling -- Visual Basic and the .NET Framework -- Creating Windows Applications -- Controls for Windows Applications -- Object-Oriented Programming with VB .NET, Part 1 -- Object-Oriented Programming with VB .NET, Part 2 -- Creating Custom Controls -- Writing Console Applications -- Creating MDI Applications -- Working with Text and Numbers -- Working with Dates and Times -- File Access and Management -- Graphics and Printing -- Processing XML -- Database Access with ADO.NET -- Creating Web Applications with ASP. NET -- Controls for Web Applications -- Database Access in Web Applications -- Creating and Using Web Services -- Developing Customized Web Controls -- Debugging and Deploying Your Applications -- Changes in Visual Basic .NET -- The Upgrade Wizard -- VB.NET Exceptions -- Compiler Options -- Index. |
| Record Nr. | UNINA-9910809897703321 |
|
Aitken Peter G
|
||
| Scottsdale, Ariz., : Coriolis Group Books | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||