top

  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.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.
Excel VBA programming for dummies / / by John Walkenbach
Excel VBA programming for dummies / / by John Walkenbach
Autore Walkenbach John
Edizione [2nd ed.]
Pubbl/distr/stampa Hoboken, New Jersey : , : Wiley Publishing, Inc., , 2010
Descrizione fisica 1 online resource (432 p.)
Disciplina 005.368/2
005.54
Collana For Dummies
Soggetto topico Electronic spreadsheets
Business - Computer programs
Soggetto genere / forma Electronic books.
ISBN 1-282-68510-4
9786612685101
1-118-25765-0
0-470-63275-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel® VBA Programming For Dummies®, 2nd Edition; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Is This the Right Book?; So You Want to Be a Programmer . . .; Why Bother?; What I Assume about You; Obligatory Typographical Conventions Section; Check Your Security Settings; How This Book Is Organized; Icons Used in This Book; Getting the Sample Files; Now What?; Part I: Introducing VBA; Chapter 1: What Is VBA?; Okay, So What Is VBA?; What Can You Do with VBA?; Advantages and Disadvantages of VBA; VBA in a Nutshell
An Excursion into VersionsChapter 2: Jumping Right In; First Things First; What You'll Be Doing; Taking the First Steps; Recording the Macro; Testing the Macro; Examining the Macro; Modifying the Macro; Saving Workbooks That Contain Macros; Understanding Macro Security; More about the NameAndTime Macro; Part II: How VBA Works with Excel; Chapter 3: Working In the Visual Basic Editor; What Is the Visual Basic Editor?; Working with the Project Window; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object?
Climbing the Object HierarchyWrapping Your Mind around Collections; Referring to Objects; Diving into Object Properties and Methods; Finding Out More; Chapter 5: VBA Sub and Function Procedures; Subs versus Functions; Executing Sub procedures; Executing Function procedures; Chapter 6: Using the Excel Macro Recorder; Is It Live or Is It VBA?; Recording Basics; Preparing to Record; Relative or Absolute?; What Gets Recorded?; Recording Options; Is This Thing Efficient?; Part III: Programming Concepts; Chapter 7: Essential VBA Language Elements; Using Comments in Your VBA Code
Using Variables, Constants, and Data TypesUsing Assignment Statements; Working with Arrays; Using Labels; Chapter 8: Working with Range Objects; A Quick Review; Other Ways to Refer to a Range; Some Useful Range Object Properties; Some Useful Range Object Methods; Chapter 9: Using VBA and Worksheet Functions; What Is a Function?; Using Built-In VBA Functions; Using Worksheet Functions in VBA; More about Using Worksheet Functions; Using Custom Functions; Chapter 10: Controlling Program Flow and Making Decisions; Going with the Flow, Dude; The GoTo Statement; Knocking Your Code for a Loop
Looping through a CollectionChapter 11: Automatic Procedures and Events; Preparing for the Big Event; Where Does the VBA Code Go?; Writing an Event-Handler Procedure; Introductory Examples; Examples of Activation Events; Other Worksheet-Related Events; Events Not Associated with Objects; Chapter 12: Error-Handling Techniques; Types of Errors; An Erroneous Example; Handling Errors Another Way; Handling Errors: The Details; An Intentional Error; Chapter 13: Bug Extermination Techniques; Species of Bugs; Identifying Bugs; Debugging Techniques; About the Debugger; Bug Reduction Tips
Chapter 14: VBA Programming Examples
Record Nr. UNINA-9910140569703321
Walkenbach John  
Hoboken, New Jersey : , : Wiley Publishing, Inc., , 2010
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel VBA programming for dummies / / by John Walkenbach
Excel VBA programming for dummies / / by John Walkenbach
Autore Walkenbach John
Edizione [2nd ed.]
Pubbl/distr/stampa Hoboken, New Jersey : , : Wiley Publishing, Inc., , 2010
Descrizione fisica 1 online resource (432 p.)
Disciplina 005.368/2
005.54
Collana For Dummies
Soggetto topico Electronic spreadsheets
Business - Computer programs
ISBN 1-282-68510-4
9786612685101
1-118-25765-0
0-470-63275-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel® VBA Programming For Dummies®, 2nd Edition; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Is This the Right Book?; So You Want to Be a Programmer . . .; Why Bother?; What I Assume about You; Obligatory Typographical Conventions Section; Check Your Security Settings; How This Book Is Organized; Icons Used in This Book; Getting the Sample Files; Now What?; Part I: Introducing VBA; Chapter 1: What Is VBA?; Okay, So What Is VBA?; What Can You Do with VBA?; Advantages and Disadvantages of VBA; VBA in a Nutshell
An Excursion into VersionsChapter 2: Jumping Right In; First Things First; What You'll Be Doing; Taking the First Steps; Recording the Macro; Testing the Macro; Examining the Macro; Modifying the Macro; Saving Workbooks That Contain Macros; Understanding Macro Security; More about the NameAndTime Macro; Part II: How VBA Works with Excel; Chapter 3: Working In the Visual Basic Editor; What Is the Visual Basic Editor?; Working with the Project Window; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object?
Climbing the Object HierarchyWrapping Your Mind around Collections; Referring to Objects; Diving into Object Properties and Methods; Finding Out More; Chapter 5: VBA Sub and Function Procedures; Subs versus Functions; Executing Sub procedures; Executing Function procedures; Chapter 6: Using the Excel Macro Recorder; Is It Live or Is It VBA?; Recording Basics; Preparing to Record; Relative or Absolute?; What Gets Recorded?; Recording Options; Is This Thing Efficient?; Part III: Programming Concepts; Chapter 7: Essential VBA Language Elements; Using Comments in Your VBA Code
Using Variables, Constants, and Data TypesUsing Assignment Statements; Working with Arrays; Using Labels; Chapter 8: Working with Range Objects; A Quick Review; Other Ways to Refer to a Range; Some Useful Range Object Properties; Some Useful Range Object Methods; Chapter 9: Using VBA and Worksheet Functions; What Is a Function?; Using Built-In VBA Functions; Using Worksheet Functions in VBA; More about Using Worksheet Functions; Using Custom Functions; Chapter 10: Controlling Program Flow and Making Decisions; Going with the Flow, Dude; The GoTo Statement; Knocking Your Code for a Loop
Looping through a CollectionChapter 11: Automatic Procedures and Events; Preparing for the Big Event; Where Does the VBA Code Go?; Writing an Event-Handler Procedure; Introductory Examples; Examples of Activation Events; Other Worksheet-Related Events; Events Not Associated with Objects; Chapter 12: Error-Handling Techniques; Types of Errors; An Erroneous Example; Handling Errors Another Way; Handling Errors: The Details; An Intentional Error; Chapter 13: Bug Extermination Techniques; Species of Bugs; Identifying Bugs; Debugging Techniques; About the Debugger; Bug Reduction Tips
Chapter 14: VBA Programming Examples
Record Nr. UNINA-9910830060403321
Walkenbach John  
Hoboken, New Jersey : , : Wiley Publishing, Inc., , 2010
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Unix for dummies [[electronic resource] /] / by John R. Levine and Margaret Levine Young
Unix for dummies [[electronic resource] /] / by John R. Levine and Margaret Levine Young
Autore Levine John R
Edizione [5th ed.]
Pubbl/distr/stampa Hoboken, NJ, : Wiley Pub., c2004
Descrizione fisica 1 online resource (410 p.)
Disciplina 005.368/2
Altri autori (Persone) YoungMargaret Levine
Collana --For dummies
Soggetto topico Operating systems (Computers)
Soggetto genere / forma Electronic books.
ISBN 0-7645-6864-7
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto UNIX For Dummies, 5th Edition; About the Authors; Dedication; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Authors' Note; Part I: Before the Beginning; Chapter 1: Log Me In, UNIX!; Turning Your Computer On and Off; Hey, UNIX! I Want to Log In; Logging In: U( NIX) Can Call Me Al; Password Smarts; Ciao, UNIX!; Chapter 2: What Is UNIX, Anyway?; Why Do We Ask Such Dumb Questions?; How Can You Tell?; Cracking the Shell
Are Any Good Programs On? Finally! You're Ready to Work; Chapter 3: A Few Lines on Linux; Out of the Frozen North; What's Old, What's New; Where's Linux?; A Whole Lotta Kinds of Linux; Part II: Some Basic Stuff; Chapter 4: Opening Windows on UNIX; UNIX Gets All GUI; Stupid Window Manager Tricks; CDE: A Desktop for All Seasons; What's the " K" Stand For?; You Mean the Little Guys with the Hats?; Terminal Happenings; Chapter 5: Files for Fun and Profit; What Files Do You Have?; Roger, I Copy; Nuking Files Back to the Stone Age; What's in a Name ( Reprise); Looking at the Guts of a File
Is This a Printout I See Before Me? Who Goes There?; Chapter 6: Directories for Fun and Profit; Good News for Windows Users; What Is a Directory?; Divide and Conquer; There's No Place Like Home; Putting Your Ducks in a Row; Putting Your Ducks on the Web; A Map of UNIX; Chapter 7: The Shell Game; This Output Is Going to Havana: Redirection; Gurgle, Gurgle: Running Data through Pipes; Wild and Crazy Wildcards; History Repeats Itself; Do I Have to Type the Same Things Every Time I Log In?; Terminal Options; Chapter 8: Where's That File?; The Search Is On; What to Do with Files after You Find Them
Searching Is Slow! A File by Any Other Name; Chapter 9: Printing ( The Gutenberg Thing); Printing Stuff: Daemons at Work; Finding Your Printout; " Help! I've Printed, and It Won't Shut Up!"; Prettying Up Your Printouts; Troff, Nroff, Groff!; Printing for the PostScript-Challenged; Part III: Getting Things Done; Chapter 10: Writing Deathless Prose; UNIX Has Its Way with Words; Shy vi, the Princess of Text Editors; A Novel Concept in Editing: emacs Makes Sense; A Peek at pico; Talk to Mr. ed; Chapter 11: Umpteen Useful UNIX Utilities; Comparing Apples and Oranges; Assorted Files
Time Is Money - Steal Some Today! Squashing Your Files; What's in That File?; Chapter 12: Installing Software Can Be Tricky; The Software Stork; You Too Can Be a Script Writer; Borrowing Other People's Programs; Stealing Software from the Network; Real Software Installation; Chapter 13: Juggling a Bunch of Programs; So What Is a Process, Anyway?; Any Processes in the House?; Starting Background Processes; The Magic of Job Control; Chapter 14: Taming Linux; Congratulations! You're a System Administrator!; A Pride of Linuxes; " I Need Help!"; Part IV: UNIX and the Net
Chapter 15: Your Computer Is Not Alone
Record Nr. UNINA-9910449930603321
Levine John R  
Hoboken, NJ, : Wiley Pub., c2004
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Unix for dummies [[electronic resource] /] / by John R. Levine and Margaret Levine Young
Unix for dummies [[electronic resource] /] / by John R. Levine and Margaret Levine Young
Autore Levine John R
Edizione [5th ed.]
Pubbl/distr/stampa Hoboken, NJ, : Wiley Pub., c2004
Descrizione fisica 1 online resource (410 p.)
Disciplina 005.368/2
Altri autori (Persone) YoungMargaret Levine
Collana --For dummies
Soggetto topico Operating systems (Computers)
ISBN 1-118-04390-1
0-7645-6864-7
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto UNIX For Dummies, 5th Edition; About the Authors; Dedication; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Authors' Note; Part I: Before the Beginning; Chapter 1: Log Me In, UNIX!; Turning Your Computer On and Off; Hey, UNIX! I Want to Log In; Logging In: U( NIX) Can Call Me Al; Password Smarts; Ciao, UNIX!; Chapter 2: What Is UNIX, Anyway?; Why Do We Ask Such Dumb Questions?; How Can You Tell?; Cracking the Shell
Are Any Good Programs On? Finally! You're Ready to Work; Chapter 3: A Few Lines on Linux; Out of the Frozen North; What's Old, What's New; Where's Linux?; A Whole Lotta Kinds of Linux; Part II: Some Basic Stuff; Chapter 4: Opening Windows on UNIX; UNIX Gets All GUI; Stupid Window Manager Tricks; CDE: A Desktop for All Seasons; What's the " K" Stand For?; You Mean the Little Guys with the Hats?; Terminal Happenings; Chapter 5: Files for Fun and Profit; What Files Do You Have?; Roger, I Copy; Nuking Files Back to the Stone Age; What's in a Name ( Reprise); Looking at the Guts of a File
Is This a Printout I See Before Me? Who Goes There?; Chapter 6: Directories for Fun and Profit; Good News for Windows Users; What Is a Directory?; Divide and Conquer; There's No Place Like Home; Putting Your Ducks in a Row; Putting Your Ducks on the Web; A Map of UNIX; Chapter 7: The Shell Game; This Output Is Going to Havana: Redirection; Gurgle, Gurgle: Running Data through Pipes; Wild and Crazy Wildcards; History Repeats Itself; Do I Have to Type the Same Things Every Time I Log In?; Terminal Options; Chapter 8: Where's That File?; The Search Is On; What to Do with Files after You Find Them
Searching Is Slow! A File by Any Other Name; Chapter 9: Printing ( The Gutenberg Thing); Printing Stuff: Daemons at Work; Finding Your Printout; " Help! I've Printed, and It Won't Shut Up!"; Prettying Up Your Printouts; Troff, Nroff, Groff!; Printing for the PostScript-Challenged; Part III: Getting Things Done; Chapter 10: Writing Deathless Prose; UNIX Has Its Way with Words; Shy vi, the Princess of Text Editors; A Novel Concept in Editing: emacs Makes Sense; A Peek at pico; Talk to Mr. ed; Chapter 11: Umpteen Useful UNIX Utilities; Comparing Apples and Oranges; Assorted Files
Time Is Money - Steal Some Today! Squashing Your Files; What's in That File?; Chapter 12: Installing Software Can Be Tricky; The Software Stork; You Too Can Be a Script Writer; Borrowing Other People's Programs; Stealing Software from the Network; Real Software Installation; Chapter 13: Juggling a Bunch of Programs; So What Is a Process, Anyway?; Any Processes in the House?; Starting Background Processes; The Magic of Job Control; Chapter 14: Taming Linux; Congratulations! You're a System Administrator!; A Pride of Linuxes; " I Need Help!"; Part IV: UNIX and the Net
Chapter 15: Your Computer Is Not Alone
Record Nr. UNINA-9910783278003321
Levine John R  
Hoboken, NJ, : Wiley Pub., c2004
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Unix for dummies / / by John R. Levine and Margaret Levine Young
Unix for dummies / / by John R. Levine and Margaret Levine Young
Autore Levine John R
Edizione [5th ed.]
Pubbl/distr/stampa Hoboken, NJ, : Wiley Pub., c2004
Descrizione fisica 1 online resource (410 p.)
Disciplina 005.368/2
Altri autori (Persone) YoungMargaret Levine
Collana --For dummies
Soggetto topico Operating systems (Computers)
ISBN 1-118-04390-1
0-7645-6864-7
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto UNIX For Dummies, 5th Edition; About the Authors; Dedication; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Authors' Note; Part I: Before the Beginning; Chapter 1: Log Me In, UNIX!; Turning Your Computer On and Off; Hey, UNIX! I Want to Log In; Logging In: U( NIX) Can Call Me Al; Password Smarts; Ciao, UNIX!; Chapter 2: What Is UNIX, Anyway?; Why Do We Ask Such Dumb Questions?; How Can You Tell?; Cracking the Shell
Are Any Good Programs On? Finally! You're Ready to Work; Chapter 3: A Few Lines on Linux; Out of the Frozen North; What's Old, What's New; Where's Linux?; A Whole Lotta Kinds of Linux; Part II: Some Basic Stuff; Chapter 4: Opening Windows on UNIX; UNIX Gets All GUI; Stupid Window Manager Tricks; CDE: A Desktop for All Seasons; What's the " K" Stand For?; You Mean the Little Guys with the Hats?; Terminal Happenings; Chapter 5: Files for Fun and Profit; What Files Do You Have?; Roger, I Copy; Nuking Files Back to the Stone Age; What's in a Name ( Reprise); Looking at the Guts of a File
Is This a Printout I See Before Me? Who Goes There?; Chapter 6: Directories for Fun and Profit; Good News for Windows Users; What Is a Directory?; Divide and Conquer; There's No Place Like Home; Putting Your Ducks in a Row; Putting Your Ducks on the Web; A Map of UNIX; Chapter 7: The Shell Game; This Output Is Going to Havana: Redirection; Gurgle, Gurgle: Running Data through Pipes; Wild and Crazy Wildcards; History Repeats Itself; Do I Have to Type the Same Things Every Time I Log In?; Terminal Options; Chapter 8: Where's That File?; The Search Is On; What to Do with Files after You Find Them
Searching Is Slow! A File by Any Other Name; Chapter 9: Printing ( The Gutenberg Thing); Printing Stuff: Daemons at Work; Finding Your Printout; " Help! I've Printed, and It Won't Shut Up!"; Prettying Up Your Printouts; Troff, Nroff, Groff!; Printing for the PostScript-Challenged; Part III: Getting Things Done; Chapter 10: Writing Deathless Prose; UNIX Has Its Way with Words; Shy vi, the Princess of Text Editors; A Novel Concept in Editing: emacs Makes Sense; A Peek at pico; Talk to Mr. ed; Chapter 11: Umpteen Useful UNIX Utilities; Comparing Apples and Oranges; Assorted Files
Time Is Money - Steal Some Today! Squashing Your Files; What's in That File?; Chapter 12: Installing Software Can Be Tricky; The Software Stork; You Too Can Be a Script Writer; Borrowing Other People's Programs; Stealing Software from the Network; Real Software Installation; Chapter 13: Juggling a Bunch of Programs; So What Is a Process, Anyway?; Any Processes in the House?; Starting Background Processes; The Magic of Job Control; Chapter 14: Taming Linux; Congratulations! You're a System Administrator!; A Pride of Linuxes; " I Need Help!"; Part IV: UNIX and the Net
Chapter 15: Your Computer Is Not Alone
Record Nr. UNINA-9910818495903321
Levine John R  
Hoboken, NJ, : Wiley Pub., c2004
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui