VBA and macros for Microsoft Office Excel 2007
(eBook)
Author
Contributors
Published
Indianapolis, Ind. : Que, 2007.
Format
eBook
ISBN
0789736829, 9780789736826
Physical Desc
1 online resource
Status
Description
Loading Description...
Also in this Series
Checking series information...
Subjects
LC Subjects
OCLC Fast Subjects
More Details
Language
English
Notes
Description
"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
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Jelen, B., & Syrstad, T. (2007). VBA and macros for Microsoft Office Excel 2007 . Que.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Jelen, Bill and Tracy. Syrstad. 2007. VBA and Macros for Microsoft Office Excel 2007. Que.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Jelen, Bill and Tracy. Syrstad. VBA and Macros for Microsoft Office Excel 2007 Que, 2007.
MLA Citation, 9th Edition (style guide)Jelen, Bill., and Tracy Syrstad. VBA and Macros for Microsoft Office Excel 2007 Que, 2007.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
fecadacb-9adb-f3a2-ec39-46e3b5923f28-eng
Grouping Information
Grouped Work ID | fecadacb-9adb-f3a2-ec39-46e3b5923f28-eng |
---|---|
Full title | vba and macros for microsoft office excel 2007 |
Author | jelen bill |
Grouping Category | book |
Last Update | 2024-09-06 16:31:08PM |
Last Indexed | 2024-09-28 04:46:45AM |
Marc Record
First Detected | Jul 29, 2024 03:56:38 PM |
---|---|
Last File Modification Time | Sep 06, 2024 04:32:06 PM |
MARC Record
LEADER | 03521cam a2200481 a 4500 | ||
---|---|---|---|
001 | ocn172622373 | ||
003 | OCoLC | ||
005 | 20240830103855.0 | ||
006 | m o d | ||
007 | cr unu|||||||| | ||
008 | 070917s2007 inu o 001 0 eng d | ||
020 | |a 0789736829|q (paperback) | ||
020 | |a 9780789736826|q (paperback) | ||
035 | |a (OCoLC)172622373 | ||
037 | |a CL0500000013|b Safari Books Online | ||
040 | |a UMI|b eng|e pn|c UMI|d OCLCQ|d TXJ|d CEF|d OCLCQ|d NHM|d DEBSZ|d OCLCQ|d OCLCO|d CNNAI|d OCLCF|d OCLCQ|d OCLCA|d IDEBK|d OCLCQ|d OCLCO|d AU@|d OCLCQ|d OCLCO|d UAB|d OCLCQ|d OCLCO|d OCLCQ|d OCLCO|d OCLCQ|d OCLCL | ||
049 | |a FMGA | ||
050 | 4 | |a HF5548.4.M523|b J457 2007 | |
082 | 0 | 4 | |a 005.36 E96 Jel 2007 [ONLINE] |
100 | 1 | |a Jelen, Bill. | |
245 | 1 | 0 | |a VBA and macros for Microsoft Office Excel 2007 /|c Bill Jelen, Tracy Syrstad. |
246 | 3 | |a Visual Basic for applications and macros for Microsoft Office Excel 2007 | |
260 | |a Indianapolis, Ind. :|b Que,|c 2007. | ||
300 | |a 1 online resource | ||
336 | |a text|b txt|2 rdacontent | ||
337 | |a computer|b c|2 rdamedia | ||
338 | |a online resource|b cr|2 rdacarrier | ||
490 | 1 | |a Business solutions | |
505 | 0 | |a 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. | |
520 | 1 | |a "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 | |
588 | 0 | |a Print version record. | |
630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
630 | 0 | 0 | |a Microsoft Visual Basic for applications. |
630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 blmlsh |
630 | 0 | 7 | |a Microsoft Visual Basic for applications.|2 blmlsh |
630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast|0 (OCoLC)fst01366659 |
630 | 0 | 7 | |a Microsoft Visual Basic for applications.|2 fast|0 (OCoLC)fst01382545 |
650 | 0 | |a Business|x Computer programs.|0 http://id.loc.gov/authorities/subjects/sh85018263 | |
650 | 0 | |a Electronic spreadsheets.|0 http://id.loc.gov/authorities/subjects/sh85042371 | |
700 | 1 | |a Syrstad, Tracy. | |
758 | |i has work:|a VBA And Macros For Microsoft Office Excel 2007 (Text)|1 https://id.oclc.org/worldcat/entity/E39PCXWGT39MyCxfB3xjpyYCYq|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
830 | 0 | |a Business solutions.|0 http://id.loc.gov/authorities/names/n2004110689 | |
856 | 4 | 0 | |u https://www.aclib.us/OReilly |