Microsoft® Office Excel 2003 Programming Inside Out
You're a sophisticated user of Excel-a real pro with spreadsheets-so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hun...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627691806719 |
Tabla de Contenidos:
- Microsoft® Office Excel 2003 Programming Inside Out; We'd Like to Hear from You; About the CD; Using the CD; System Requirements; Support Information; Conventions and Features Used in this Book; Design Conventions; 1. Preliminaries; Creating Smart Documents; Creating Document Workspaces; Implementing Information Rights Management; Comparing Workbooks Side By Side; Getting Information with the Research Task Pane; Using Extended XML Capabilities; Mapping Excel Data to XML Schemas; Publishing Spreadsheets with Web Components; 2. Exploring Excel; Worksheets; Cells and Ranges; The Excel Interface
- Formulas2. Visual Basic for Applications; Methods; Events; Collections; Working with Macros; Running a Macro; Assigning a Macro to a Toolbar Button; Assigning a Macro to a Menu Item; Debugging a Macro; Implementing Macro Security and Digital Signatures; Digitally Signing Workbooks and Macros; Using Digital Signatures with the High Macro Security Setting; 4. VBA Programming Starter Kit; Recognizing Parts of the Visual Basic Editor; The Insert Menu; The Format Menu; The Debug Menu; The Run Menu; The Tools Menu; Customizing the Visual Basic Editor; Managing Code Windows; Adding Code
- Notes on Programming Style and Code ReadabilityDeveloping Projects with the Project Explorer; Deleting VBA Modules; Copying Modules Between Projects; Declaring Variables, Constants, and Data Types; Defining Data Types; Defining Constants; Handling Strings; Handling Dates and Times; Handling Variants and Data Type Conversions; Understanding Variable Scope and Lifetimes; Assigning Values to Variables; Working with Arrays; Creating Multidimensional Arrays; Creating Dynamic Arrays; Writing to the Screen and Accepting Input; Creating an Input Box; Defining Object Variables
- Creating Custom Data TypesControlling Program Flow; Select Case Statements; Loops; Logical Loops; GoTo Statement; Error Handling; 5. Creating Sub and Function Procedures; Running a Sub Procedure from Within Another Procedure; Retaining Values Between Procedure Calls; Defining Function Procedures; Running Function Procedures; Passing Arguments to Procedures; Passing Named Arguments; Organizing for Success; 3. The Excel Object Model; ActiveChart Property; ActiveSheet Property; ActiveWindow Property; ActiveWorkbook Property; DisplayAlerts Property; RangeSelection Property; Selection Property
- StatusBar PropertyScreenUpdating Property; ThisWorkbook Property; Methods; CalculateFull Method; FindFile Method; InputBox Method; Intersect Method; OnKey Method; SendKeys Method; 7. Workbooks and Worksheets; Opening Workbooks; Activating Workbooks; Closing Workbooks; Workbook Properties; Displaying Drawing Objects; Managing File Settings; Requiring a Password to Open a Workbook; Protecting Workbooks from Changes; Workbook Methods; AddToFavorites Method; FollowHyperlink Method; Printing and Previewing Workbooks; The Sheets and Worksheets Collections; Name Property; Visible Property; Methods
- Delete Method
