book

Excel 2007 VBA Programming with XML and ASP

by Julitta Korol

December 2008

Intermediate to advanced

879 pages

38h 52m

English

Jones & Bartlett Learning

Read now

Unlock full access

What Are Macros?Common Uses for MacrosExcel 2007 Versions and File FormatsMacro Security SettingsPlanning a MacroRecording a MacroExecuting MacrosEditing MacrosMacro CommentsAnalyzing the Macro CodeCleaning Up the Macro CodeTesting the Modified MacroTwo Levels of Macro ExecutionImproving Your MacroRenaming the MacroOther Methods of Running MacrosSaving MacrosPrinting MacrosStoring Macros in the Personal Macro WorkbookChapter Summary
Understanding the Project Explorer WindowUnderstanding the Properties WindowUnderstanding the Code WindowOther Windows in the Visual Basic Editor WindowAssigning a Name to the VBA ProjectRenaming the ModuleUnderstanding Digital SignaturesCreating a Digital CertificateSigning a VBA ProjectChapter Summary
Understanding Instructions, Modules, and ProceduresCalling a Procedure from Another ProjectUnderstanding Objects, Properties, and MethodsMicrosoft Excel Object ModelWriting VBA StatementsUnderstanding VBA ErrorsIn Search of HelpOn-the-fly Syntax and Programming AssistanceUsing the Object BrowserUsing the VBA Object LibraryLocating Procedures with the Object BrowserUsing the Immediate WindowLearning about ObjectsWorking with Worksheet CellsWorking with Workbooks and WorksheetsWorking with WindowsManaging the Excel ApplicationChapter Summary

Saving Results of VBA StatementsWhat Are Variables?Data TypesHow to Create VariablesHow to Declare VariablesSpecifying the Data Type of a VariableAssigning Values to VariablesForcing Declaration of VariablesUnderstanding the Scope of VariablesLifetime of VariablesUnderstanding and Using Static VariablesDeclaring and Using Object VariablesFinding a Variable DefinitionUsing Constants in VBA ProceduresChapter Summary
About Function ProceduresPassing ArgumentsLocating Built-in FunctionsUsing Master Procedures and SubproceduresChapter Summary
Relational and Logical OperatorsIf …Then StatementDecisions Based on More Than One ConditionIf Block Instructions and IndentingIf…Then…Else StatementIf…Then…ElseIf StatementNested If…Then StatementsSelect Case StatementChapter Summary
Do Loops: Do...While and Do...UntilWatching a Procedure ExecuteWhile...Wend LoopFor...Next LoopFor Each...Next LoopExiting Loops EarlyNested LoopsChapter Summary
What Is an Array?Declaring ArraysArray Upper and Lower BoundsUsing Arrays in VBA ProceduresArrays and Looping StatementsUsing a Two-Dimensional ArrayStatic and Dynamic ArraysArray FunctionsErrors in ArraysParameter ArraysChapter Summary
Working with CollectionsCreating a ClassChapter Summary
Testing VBA ProceduresUsing the Watch WindowUsing Quick WatchUsing the Locals Window and the Call Stack Dialog BoxStepping through VBA ProceduresChapter Summary
Understanding and Using Conditional CompilationNavigating with BookmarksTrapping ErrorsChapter Summary
Manipulating Files and FoldersChapter Summary
Finding Information about Files with WSHCreating a Text File Using WSHPerforming Other Operations with WSHChapter Summary
File Access TypesWorking with Sequential FilesWorking with Random Access FilesWorking with Binary FilesChapter Summary
Launching ApplicationsMoving between ApplicationsControlling Another ApplicationOther Methods of Controlling ApplicationsCreating Automation ObjectsChapter Summary
Object LibrariesConnecting to AccessOpening an Access DatabasePerforming Access Tasks from ExcelRetrieving Access Data into an Excel WorksheetTransferring the Excel Spreadsheet to an Access DatabaseChapter Summary
Introduction to Event ProceduresWriting Your First Event ProcedureEnabling and Disabling EventsEvent SequencesWorksheet EventsWorkbook EventsPivotTable EventsChart EventsEvents Recognized by the Application ObjectQuery Table EventsChapter Summary
Excel Dialog BoxesFile Open and File Save As Dialog BoxesGetOpenFilename and GetSaveAsFilename MethodsChapter Summary
Creating FormsTools for Creating User FormsPlacing Controls on a FormSample Application 1: Info SurveySample Application 2: Students and ExamsChapter Summary
Performing Basic Formatting Tasks with VBAPerforming Advanced Formatting Tasks with VBAChapter Summary
Working with Shortcut MenusA Quick Overview of the Ribbon InterfaceRibbon Programming with XML and VBACustomizing the Microsoft Office Button MenuCustomizing the Quick Access Toolbar (QAT)Chapter Summary
Controlling the Page SetupPreviewing a WorksheetChanging the Active PrinterPrinting a WorksheetDisabling Printing and Print PreviewingUsing Printing EventsSending E-mail from ExcelChapter Summary
Creating a PivotTable ReportRemoving PivotTable Detail Worksheets with VBACreating a PivotTable Report ProgrammaticallyCreating a PivotTable Report from an Access DatabaseFormatting, Grouping, and Sorting a PivotTable ReportHiding Items in a PivotTableAdding Calculated Fields and Items to a PivotTableCreating a PivotChart Report Using VBAChapter Summary
Understanding Excel TablesCreating a TableCreating a Table Using VBAUnderstanding Column Headings in the TableMultiple Tables in a WorksheetWorking with the Excel ListObjectDeleting Worksheet TablesChapter Summary
Tab ObjectSpeech ObjectSpellingOptions ObjectCellFormat ObjectCharacters ObjectAutoCorrect ObjectFormatCondition ObjectGraphic ObjectCustomProperty ObjectSort ObjectExcel8CompatibilityMode PropertyChapter Summary
The Visual Basic Editor Object ModelUnderstanding the VBE ObjectsAccessing the VBA ProjectFinding Information about a VBA ProjectWorking with ModulesWorking with ProceduresWorking with UserFormsWorking with ReferencesWorking with WindowsWorking with VBE Menus and ToolbarsChapter Summary
Creating Hyperlinks Using VBACreating and Publishing HTML Files Using VBAWeb QueriesRefreshing DataChapter Summary
The ASP Object ModelHTML and VBScriptCreating an ASP PageInstalling Internet Information Services (IIS)Creating a Virtual DirectoryRunning Your First ASP ScriptSending Data from an HTML Form to an Excel WorkbookSending Excel Data to the Internet BrowserCreating Charts in ASPChapter Summary
What Is XML?Well-Formed XML DocumentsValidating XML DocumentsEditing and Viewing an XML DocumentOpening an XML Document in ExcelWorking with XML MapsWorking with XML TablesExporting an XML TableXML Export PrecautionsValidating XML DataProgramming XML MapsCreating XML Schema FilesUsing XML EventsThe XML Document Object ModelWorking with XML Document NodesRetrieving Information from Element NodesXML via ADOUnderstanding NamespacesUnderstanding Open XML FilesChapter Summary
Checking Smart Tag Options in an Excel WorkbookCreating Your First Simple Smart TagStoring Smart Tag List Definition FilesUsing Custom Smart TagsInformation Lookups via ASP PagesDynamic Recognition of Smart Tag TermsManipulating Smart Tags with VBAChapter Summary