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

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

Label
VBA and macros for Microsoft Excel
Title
VBA and macros for Microsoft Excel
Statement of responsibility
Bill Jelen, Tracy Syrstad
Creator
Contributor
Subject
Genre
Language
eng
Summary
Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!
Member of
Cataloging source
N$T
http://library.link/vocab/creatorName
Jelen, Bill
Dewey number
005.54
Illustrations
illustrations
Index
index present
Language note
English
LC call number
HF5548.4.M523
LC item number
J457 2004eb
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
  • COMPUTERS
  • Business
  • Electronic spreadsheets
  • Commerce
  • Business & Economics
  • Marketing & Sales
Label
VBA and macros for Microsoft Excel, Bill Jelen, Tracy Syrstad
Instantiates
Publication
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 4.
  • User-defined functions
  • 5.
  • Looping
  • 6.
  • R1C1 style formulas
  • 7.
  • Names
  • 8.
  • Event programming
  • I.
  • 9.
  • Userforms -- an introduction
  • II.
  • Automating excel power in VBA
  • 10.
  • Charts
  • 11.
  • Data mining with advanced filter
  • 12.
  • Pivot tables
  • First steps up the VBA learning curve
  • 13.
  • Excel power
  • 14.
  • Reading from and writing to the web
  • 15.
  • XML in excel 2003 professional
  • 16.
  • Automating word
  • III.
  • Techie stuff you will need to produce applications for the administrator to run
  • 1.
  • 17.
  • Arrays
  • 18.
  • Text file processing
  • 19.
  • Using access as a back end to enhance multi-user access to data
  • 20.
  • Creating classes, records, and collections
  • 21.
  • Advanced userform techniques
  • Unleash the power of excel with VBA!
  • 22.
  • Windows application programming interface (API)
  • 23.
  • Handling errors
  • 24.
  • Using custom menus to run macros
  • 25.
  • Add-ins
  • 26.
  • Case study -- designing an excel application
  • 2.
  • This sounds like BASIC, so why doesn't it look familiar?
  • 3.
  • Referring to ranges
Control code
59759165
Dimensions
unknown
Extent
1 online resource (xxi, 547 pages)
File format
unknown
Form of item
online
Isbn
9781280851797
Lccn
2004102247
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
http://library.link/vocab/ext/overdrive/overdriveId
ae343adf-adae-42a2-b928-50ba81c7d398
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)59759165
Label
VBA and macros for Microsoft Excel, Bill Jelen, Tracy Syrstad
Publication
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 4.
  • User-defined functions
  • 5.
  • Looping
  • 6.
  • R1C1 style formulas
  • 7.
  • Names
  • 8.
  • Event programming
  • I.
  • 9.
  • Userforms -- an introduction
  • II.
  • Automating excel power in VBA
  • 10.
  • Charts
  • 11.
  • Data mining with advanced filter
  • 12.
  • Pivot tables
  • First steps up the VBA learning curve
  • 13.
  • Excel power
  • 14.
  • Reading from and writing to the web
  • 15.
  • XML in excel 2003 professional
  • 16.
  • Automating word
  • III.
  • Techie stuff you will need to produce applications for the administrator to run
  • 1.
  • 17.
  • Arrays
  • 18.
  • Text file processing
  • 19.
  • Using access as a back end to enhance multi-user access to data
  • 20.
  • Creating classes, records, and collections
  • 21.
  • Advanced userform techniques
  • Unleash the power of excel with VBA!
  • 22.
  • Windows application programming interface (API)
  • 23.
  • Handling errors
  • 24.
  • Using custom menus to run macros
  • 25.
  • Add-ins
  • 26.
  • Case study -- designing an excel application
  • 2.
  • This sounds like BASIC, so why doesn't it look familiar?
  • 3.
  • Referring to ranges
Control code
59759165
Dimensions
unknown
Extent
1 online resource (xxi, 547 pages)
File format
unknown
Form of item
online
Isbn
9781280851797
Lccn
2004102247
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
http://library.link/vocab/ext/overdrive/overdriveId
ae343adf-adae-42a2-b928-50ba81c7d398
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)59759165

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 ...