Items related to Dissect and Learn Excel® VBA in 24 Hours: Working with...

Dissect and Learn Excel® VBA in 24 Hours: Working with sheets, workbooks, and files - Softcover

 
9781726453998: Dissect and Learn Excel® VBA in 24 Hours: Working with sheets, workbooks, and files

Synopsis

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 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® VBA in 24 Hours - A quick reference for beginners, which was written for those who are new to Excel VBA. 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 contents for all 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, a file, and multiple files, writing and reading a text file, looping through a folder of files, 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 the VBA code (or step through the VBA code by using the debugger 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", True. Alternatively, you can download the supplementary Excel file for the book. It contains almost all the VBA code stated in the book. The previous two books in the series discuss changing workbook appearance and working with worksheet ranges in Excel 2007-2016 for Windows. The forth, which will be the last book in the series focuses on working with controls and automation. It discusses, for example, adding controls to a worksheet and a UserForm, writing a Word document, sending an email via Outlook, logging in to an account on a web page, and working with various controls (such as list box, check box, button, and drop-down list) on a web page in Internet Explorer.

"synopsis" may belong to another edition of this title.

Other Popular Editions of the Same Title

Search results for Dissect and Learn Excel® VBA in 24 Hours: Working with...

Stock Image

HockSang, Liaw
ISBN 10: 1726453995 ISBN 13: 9781726453998
New PAP
Print on Demand

Seller: PBShop.store US, Wood Dale, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781726453998

Contact seller

Buy New

US$ 18.05
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

HockSang, Liaw
ISBN 10: 1726453995 ISBN 13: 9781726453998
New PAP
Print on Demand

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781726453998

Contact seller

Buy New

US$ 16.47
Convert currency
Shipping: US$ 4.37
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Liaw Hocksang
ISBN 10: 1726453995 ISBN 13: 9781726453998
New Paperback / softback
Print on Demand

Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 152. Seller Inventory # C9781726453998

Contact seller

Buy New

US$ 16.34
Convert currency
Shipping: US$ 10.99
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

HockSang, Liaw
ISBN 10: 1726453995 ISBN 13: 9781726453998
New Softcover

Seller: Ria Christie Collections, Uxbridge, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. In. Seller Inventory # ria9781726453998_new

Contact seller

Buy New

US$ 13.83
Convert currency
Shipping: US$ 15.92
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Liaw Hocksang
ISBN 10: 1726453995 ISBN 13: 9781726453998
New Taschenbuch

Seller: AHA-BUCH GmbH, Einbeck, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Taschenbuch. Condition: Neu. Neuware. Seller Inventory # 9781726453998

Contact seller

Buy New

US$ 23.81
Convert currency
Shipping: US$ 32.63
From Germany to U.S.A.
Destination, rates & speeds

Quantity: 2 available

Add to basket

Stock Image

Liaw Hocksang
ISBN 10: 1726453995 ISBN 13: 9781726453998
New Paperback

Seller: CitiRetail, Stevenage, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: new. Paperback. 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 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. 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 contents for all 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, a file, and multiple files, writing and reading a text file, looping through a folder of files, and creating and deleting folders are some of the operations. The previous two books in the series discuss changing workbook appearance and working with worksheet ranges in Excel 2007-2016 for Windows. The forth, which will be the last book in the series focuses on working with controls and automation. It discusses, for example, adding controls to a worksheet and a UserForm, writing a Word document, sending an email via Outlook, logging in to an account on a web page, and working with various controls (such as list box, check box, button, and drop-down list) on a web page in Internet Explorer. You can download the related code file(s) from _pDa_CVyeHIKXTkEV?usp=sharing Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability. Seller Inventory # 9781726453998

Contact seller

Buy New

US$ 18.45
Convert currency
Shipping: US$ 49.16
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket