| Dissect and Learn Excel(R) VBA in 24 Hours: Working with sheets, workbooks, and files Contributor(s): Hocksang, Liaw (Author) |
|
 |
ISBN: 1719966702 ISBN-13: 9781719966702 Publisher: Independently Published OUR PRICE: $9.50 Product Type: Paperback - Other Formats Published: September 2018 |
| Additional Information |
| BISAC Categories: - Computers | Desktop Applications - Spreadsheets |
| Physical Information: 0.36" H x 6" W x 9" (0.52 lbs) 154 pages |
| Descriptions, Reviews, Etc. |
| Publisher Description: No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs. And knowing them, you can easily understand the programs written by others and adopt into your programs the ideas and the efficient code that are presented in those programs. Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas and samples of VBA code to accomplish certain tasks when they are in the process of writing a program. In this series, you will see thousands of tiny working parts of VBA code that are used to accomplish many simple and yet meaningful tasks. To add a new workbook, to auto-fill a range, to sort a table of data, to generate a table of contents for all chart sheets and worksheets in a workbook, to loop through and manipulate a folder of Excel files, to place a control on the Ribbon, to send an email, and to login to an account in the Internet are some examples of these tiny working parts. This series is for readers, who have at least a basic understanding of Excel VBA programming. In order to follow the discussions in the series, a reader must know what Sub procedures and Function procedures are, what Visual Basic Editor (VBE) is, how to add a VBA module to a workbook, how to set a reference to an application's type library, how to enable the Auto List Members feature in VBE, how to use the Macro Recorder in Excel in order to find out the methods and properties of objects that you are not familiar with, how to use the Object Browser to check the complete list of members for a particular object, how to write some simple procedures, in which VBA modules you should store your VBA code, and how to use the debugging tools in VBE. If you are new to Excel VBA, please teach yourself Excel VBA before exploring the contents in the series. You may refer to my earlier book entitled Learn Excel |