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

By: Contributor(s): Material type: TextSeries: Business solutionsPublication details: Indianapolis, Ind. : Que, c2008.Edition: [2nd ed.]Description: xxiii, 598 p. : ill. ; 24 cmISBN:
  • 8131719879
Other title:
  • Visual Basic for applications and macros for Microsoft Office Excel 2007
Subject(s): DDC classification:
  • 005.54E2007 JEL [ Shelf 8]
LOC classification:
  • 005.54E2007 JEL
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
Cover image Item type Current library Home library Collection Shelving location Call number Materials specified Vol info URL Copy number Status Notes Date due Barcode Item holds Item hold queue priority Course reserves
Reference Indian Institute Of Management, Shillong 005.54E2007 JEL [ Shelf 8] (Browse shelf(Opens below)) Not for loan 0004481

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.
Copyright © 2026 Indian Institute of Management Shillong. All Rights Reserved.