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
Resource Information
The item VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in University of Missouri Libraries.This item is available to borrow from 2 library branches.
Resource Information
The item VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in University of Missouri Libraries.
This item is available to borrow from 2 library branches.
- 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
- Language
- eng
- Extent
- 1 online resource
- 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
- Isbn
- 9780789736826
- 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
- Subject
-
- Business -- Computer programs
- Business -- Computer programs
- Business -- Computer programs
- Electronic spreadsheets
- Electronic spreadsheets
- Electronic spreadsheets
- Microsoft Excel (Computer file)
- Microsoft Excel (Computer file)
- Microsoft Excel (Computer file)
- Microsoft Visual Basic for applications
- Microsoft Visual Basic for applications
- Microsoft Visual Basic for applications
- 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
- 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
- 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
- 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
Subject
- Business -- Computer programs
- Business -- Computer programs
- Business -- Computer programs
- Electronic spreadsheets
- Electronic spreadsheets
- Electronic spreadsheets
- Microsoft Excel (Computer file)
- Microsoft Excel (Computer file)
- Microsoft Excel (Computer file)
- Microsoft Visual Basic for applications
- Microsoft Visual Basic for applications
- Microsoft Visual Basic for applications
Member of
Library Links
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.library.missouri.edu/portal/VBA-and-macros-for-Microsoft-Office-Excel-2007/R8gQSXfasKA/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.library.missouri.edu/portal/VBA-and-macros-for-Microsoft-Office-Excel-2007/R8gQSXfasKA/">VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.library.missouri.edu/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.library.missouri.edu/">University of Missouri Libraries</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.library.missouri.edu/portal/VBA-and-macros-for-Microsoft-Office-Excel-2007/R8gQSXfasKA/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.library.missouri.edu/portal/VBA-and-macros-for-Microsoft-Office-Excel-2007/R8gQSXfasKA/">VBA and macros for Microsoft Office Excel 2007, Bill Jelen, Tracy Syrstad</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.library.missouri.edu/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.library.missouri.edu/">University of Missouri Libraries</a></span></span></span></span></div>
