Welcome to  UTAMU Library OPAC
Amazon cover image
Image from Amazon.com

VBA and Macros for Microsoft Office Excel 2007 / Bill "MrExcel" Jelen, Tracy Syrstad.

By: Contributor(s): Material type: TextTextSeries: Business solutionsPublication details: Indianapolis, Ind. : Que, c2008.Edition: [2nd ed.]Description: xxiii, 598 p. : ill. ; 24 cmContent type:
  • text
Media type:
  • unmediated
Carrier type:
  • volume
ISBN:
  • 0789736829
  • 9780789736826
Other title:
  • Visual Basic for Applications and Macros for Microsoft Office Excel 2007
Subject(s): DDC classification:
  • 005.54 22 JEL
LOC classification:
  • HF5548.4.M523 J457 2008
Online resources:
Contents:
Unleash the power of Excel with VBA -- This sounds like BASIC, so why doesn't it look familiar? -- Referring to ranges -- User-defined functions -- Looping and flow control -- R1C1-style formulas -- What's new in Excel 2007 and what's changed -- Create and manipulate names in VBA -- Event programming -- Userforms--an introduction -- Creating charts -- Data mining with advanced filter -- Excel power -- Data visualizations and conditional formatting -- Reading from and writing to the Web -- XML in Excel 2007 -- Automating Word -- Arrays -- Text file processing -- Using Access as a back end to enhance multi-user access to data -- Creating classes, records, and collections -- Advanced userform techniques -- Windows application programming interface (API) -- Handling errors -- Customizing the ribbon to run macros -- Creating add-ins.
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Copy number Status
Books Books Main Library - Kungu General stacks Non-fiction 005.54 JEL (Browse shelf(Opens below)) 1 Available

Includes index.

Unleash the power of Excel with VBA -- This sounds like BASIC, so why doesn't it look familiar? -- Referring to ranges -- User-defined functions -- Looping and flow control -- R1C1-style formulas -- What's new in Excel 2007 and what's changed -- Create and manipulate names in VBA -- Event programming -- Userforms--an introduction -- Creating charts -- Data mining with advanced filter -- Excel power -- Data visualizations and conditional formatting -- Reading from and writing to the Web -- XML in Excel 2007 -- Automating Word -- Arrays -- Text file processing -- Using Access as a back end to enhance multi-user access to data -- Creating classes, records, and collections -- Advanced userform techniques -- Windows application programming interface (API) -- Handling errors -- Customizing the ribbon to run macros -- Creating add-ins.

There are no comments on this title.

to post a comment.
©2024 UTAMU Library