Böcker av Liaw Hocksang

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. 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(R) VBA in 24 Hours - A quick reference for beginners, which was written for those who are new to Excel VBA. I hope this series of books will serve as quick references in facilitating you to write an unlimited number of working VBA programs. Let Excel VBA work for you. Book 2: Working with ranges focuses on commonly used operations related to worksheet ranges. Selecting a range, finding the last nonempty cell in a range, retrieving the properties of a range (such as address and font), changing the format of a range, converting formulas in a range to values, conditionally formatting a range, sorting a range, filtering a range, copying a range, and exporting a range out of Excel are some of the operations. Before you can perform any operations on a range with VBA, the first important step is to get a reference to a Range object that represents the range. The first topic in this book discusses numerous ways to refer to a range. Knowing how to refer to a range builds you a solid foundation to write sensible code and to understand the VBA code written by others on working with ranges. To understand better a particular concept discussed in the book, simply copy and paste the sample VBA code stated in the book into the Immediate window or into a VBA module, and run or step through the code by using the debugger in VBE. This book focuses on worksheet ranges in Excel 2007-2016 for Windows. The next book focuses on worksheets, workbooks, and files. It discusses adding and deleting worksheets and workbooks, creating a table of contents with hyperlinks for worksheets and chart sheets in a workbook, synchronizing sheet names and code names, prompting a user to select a file in a folder, writing to a text file, and looping through all Excel files in a folder in order to work on the files - among others. You can download the related code file(s) from https: //drive.google.com/drive/folders/1Qbw5BWFD3f9w2pM_pDa_CVyeHIKXTkEV?usp=sharing

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(R) VBA in 24 Hours - A quick reference for beginners, which was written for those who are new to Excel VBA. I hope this series of books will serve as quick references in facilitating you to write an unlimited number of working VBA programs. Let Excel VBA work for you.Book 3: Working with sheets, workbooks, and files focuses on commonly used operations on sheets, workbooks, and files. Copying a sheet, protecting a sheet, creating a table of sheets with hyperlinks, saving a copy of a workbook, self-deleting a workbook, protecting a workbook, accessing a password-forgotten VBA project, prompting users to select a folder, writing and reading a text file, looping through files in a folder, and creating and deleting folders are some of the operations.To understand better a concept discussed in this book, simply copy and paste the sample VBA code into the Immediate window or a VBA module, and run (or step through) the VBA code in VBE. To execute a few lines of code that are not in a Sub procedure, simply enclose them in a new procedure in a standard VBA module. To test a Sub procedure with required arguments, simply call the procedure by passing the arguments in the Immediate window such as DeleteAllFilesUsingFSO "C: \Temp\temp2\", True.The previous two books in the series discuss changing workbook appearance and working with ranges in a worksheet. The forth, which will be the last book in this series focuses on working with controls and automation. You can download the related code file(s) from https: //drive.google.com/drive/folders/1Qbw5BWFD3f9w2pM_pDa_CVyeHIKXTkEV?usp=sharing

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 VBA code that are presented in those programs. Dissect and Learn Excel VBA in 24 Hours is a series of quick references to VBA code 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. Book 1: Changing workbook appearance focuses on changing the appearances of the worksheet cells, the worksheets of a workbook, the row and column headings, the sheet tabs, the layout view of a worksheet, the status bar, the formula bar, the Ribbon, and the Cell context menu. The main purpose of changing the appearance is to let the users to have a better working experience when they are using your program. To facilitate the process of copying the code in the book and pasting it into VBE and Custom UI Editor, you may download the code from https: //drive.google.com/file/d/0ByKhn-UYAjlQUTAtQTNoVVB6MTQ/view.This book ends with a sample program that adopts most of the ideas that are discussed in the book. You may download the program for Excel 2010-2016 (https: //drive.google.com/file/d/0ByKhn-UYAjlQZ1Bvb0JqVzVxVTg/view) to see how it changes the appearance of a workbook. You can download the related code file(s) from https: //drive.google.com/drive/folders/1Qbw5BWFD3f9w2pM_pDa_CVyeHIKXTkEV?usp=sharing