Coverart for item
The Resource VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad

VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad

Label
VBA and macros for Microsoft Office Excel 2007
Title
VBA and macros for Microsoft Office Excel 2007
Statement of responsibility
Bill Jelen, Tracy Syrstad
Title variation
Visual Basic for applications and macros for Microsoft Office Excel 2007
Creator
Contributor
Subject
Language
eng
Summary
"This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you."--Jacket
Member of
Cataloging source
UMI
http://library.link/vocab/creatorName
Jelen, Bill
Dewey number
005.36 E96 Jel 2007 [ONLINE]
Index
index present
LC call number
HF5548.4.M523
LC item number
J457 2007
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Syrstad, Tracy
Series statement
Business solutions
http://library.link/vocab/subjectName
  • Business
  • Electronic spreadsheets
  • Business
  • Electronic spreadsheets
  • Business
  • Electronic spreadsheets
Label
VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad
Instantiates
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
Control code
172622373
Dimensions
unknown
Extent
1 online resource
Form of item
online
Isbn
9780789736826
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000013
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)172622373
Label
VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
Control code
172622373
Dimensions
unknown
Extent
1 online resource
Form of item
online
Isbn
9780789736826
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000013
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)172622373

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...