VBA and macros for Microsoft Excel
(eBook)
Author
Contributors
Published
Indianapolis, IN : Que Pub., ©2004.
Format
eBook
ISBN
0768665876, 1280851791, 6610851794, 9780768665871, 9781280851797, 9786610851799
Physical Desc
1 online resource (xxi, 547 pages) : illustrations.
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
Includes index.
Description
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!
Language
English.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Jelen, B., & Syrstad, T. (2004). VBA and macros for Microsoft Excel . Que Pub..
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Jelen, Bill and Tracy. Syrstad. 2004. VBA and Macros for Microsoft Excel. Que Pub.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Jelen, Bill and Tracy. Syrstad. VBA and Macros for Microsoft Excel Que Pub, 2004.
MLA Citation, 9th Edition (style guide)Jelen, Bill., and Tracy Syrstad. VBA and Macros for Microsoft Excel Que Pub., 2004.
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
9b84080e-12f5-0086-c161-67a4a7e374df-eng
Grouping Information
Grouped Work ID | 9b84080e-12f5-0086-c161-67a4a7e374df-eng |
---|---|
Full title | vba and macros for microsoft excel |
Author | jelen bill |
Grouping Category | book |
Last Update | 2024-09-06 16:31:08PM |
Last Indexed | 2024-09-28 03:53:14AM |
Marc Record
First Detected | Jul 29, 2024 03:56:11 PM |
---|---|
Last File Modification Time | Sep 06, 2024 04:31:27 PM |
MARC Record
LEADER | 05000cam a22005894a 4500 | ||
---|---|---|---|
001 | ocm59759165 | ||
003 | OCoLC | ||
005 | 20240830103855.0 | ||
006 | m o d | ||
007 | cr cnu|||unuuu | ||
008 | 050428s2004 inua o 001 0 eng d | ||
010 | |a 2004102247 | ||
019 | |a 62751615|a 70792474|a 313662889|a 531373573|a 630221204|a 647193106|a 729550556|a 748094787|a 984877136|a 1044281167|a 1053067985|a 1056363665|a 1058035850|a 1060992101|a 1062900668|a 1067064376|a 1086833156|a 1153033241|a 1180319839|a 1192346711|a 1240513122 | ||
020 | |a 0768665876|q (electronic bk.) | ||
020 | |a 1280851791 | ||
020 | |a 6610851794 | ||
020 | |a 9780768665871|q (electronic bk.) | ||
020 | |a 9781280851797 | ||
020 | |a 9786610851799 | ||
020 | |z 0789731290 | ||
020 | |z 9780789731296 | ||
035 | |a (OCoLC)59759165|z (OCoLC)62751615|z (OCoLC)70792474|z (OCoLC)313662889|z (OCoLC)531373573|z (OCoLC)630221204|z (OCoLC)647193106|z (OCoLC)729550556|z (OCoLC)748094787|z (OCoLC)984877136|z (OCoLC)1044281167|z (OCoLC)1053067985|z (OCoLC)1056363665|z (OCoLC)1058035850|z (OCoLC)1060992101|z (OCoLC)1062900668|z (OCoLC)1067064376|z (OCoLC)1086833156|z (OCoLC)1153033241|z (OCoLC)1180319839|z (OCoLC)1192346711|z (OCoLC)1240513122 | ||
037 | |a AE343ADF-ADAE-42A2-B928-50BA81C7D398|b OverDrive, Inc.|n http://www.overdrive.com | ||
037 | |b OverDrive, Inc.|n http://www.overdrive.com | ||
040 | |a N$T|b eng|e pn|c N$T|d OCL|d OCLCQ|d YDXCP|d OCLCQ|d IDEBK|d QT5|d VLB|d OCLCQ|d MBB|d OCLCQ|d OCLCO|d OCLCQ|d OCLCF|d OCLCA|d OCLCQ|d TEFOD|d OCLCQ|d D6H|d SUR|d OCLCQ|d SAV|d OCLCO|d CEF|d INT|d OCLCQ|d WYU|d OCLCQ|d OCLCO|d AU@|d VT2|d LDP|d HS0|d OCLCO|d OCLCQ|d OCLCO|d OCLCL | ||
049 | |a FMGA | ||
050 | 4 | |a HF5548.4.M523|b J457 2004eb | |
082 | 0 | 4 | |a 005.54|2 22 |
100 | 1 | |a Jelen, Bill.|0 http://id.loc.gov/authorities/names/n2003117264 | |
245 | 1 | 0 | |a VBA and macros for Microsoft Excel /|c Bill Jelen, Tracy Syrstad. |
260 | |a Indianapolis, IN :|b Que Pub.,|c ©2004. | ||
300 | |a 1 online resource (xxi, 547 pages) :|b illustrations. | ||
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 | |
500 | |a Includes index. | ||
505 | 0 | 0 | |g I.|t First steps up the VBA learning curve --|g 1.|t Unleash the power of excel with VBA! --|g 2.|t This sounds like BASIC, so why doesn't it look familiar? --|g 3.|t Referring to ranges --|g 4.|t User-defined functions --|g 5.|t Looping --|g 6.|t R1C1 style formulas --|g 7.|t Names --|g 8.|t Event programming --|g 9.|t Userforms -- an introduction --|g II.|t Automating excel power in VBA --|g 10.|t Charts --|g 11.|t Data mining with advanced filter --|g 12.|t Pivot tables --|g 13.|t Excel power --|g 14.|t Reading from and writing to the web --|g 15.|t XML in excel 2003 professional --|g 16.|t Automating word --|g III.|t Techie stuff you will need to produce applications for the administrator to run --|g 17.|t Arrays --|g 18.|t Text file processing --|g 19.|t Using access as a back end to enhance multi-user access to data --|g 20.|t Creating classes, records, and collections --|g 21.|t Advanced userform techniques --|g 22.|t Windows application programming interface (API) --|g 23.|t Handling errors --|g 24.|t Using custom menus to run macros --|g 25.|t Add-ins --|g 26.|t Case study -- designing an excel application. |
520 | |a 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! | ||
546 | |a English. | ||
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 fast |
630 | 0 | 7 | |a Microsoft Visual Basic for applications|2 fast |
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.|0 http://id.loc.gov/authorities/names/n2004110680 | |
758 | |i has work:|a VBA and macros for Microsoft Excel (Text)|1 https://id.oclc.org/worldcat/entity/E39PCFYmCFGxjHyPjkrhhJPkH3|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
776 | 0 | 8 | |i Print version:|a Jelen, Bill.|t VBA and macros for Microsoft Excel.|d Indianapolis, IN : Que Pub., ©2004|z 0789731290|w (DLC) 2004102247|w (OCoLC)55882061 |
830 | 0 | |a Business solutions.|0 http://id.loc.gov/authorities/names/n2004110689 | |
856 | 4 | 0 | |u https://www.aclib.us/OReilly |