Introduction To Manipulating Data Programmatically In Microsoft Excel With VBA
| Author | : | |
| Rating | : | 4.69 (697 Votes) |
| Asin | : | B00TNYC5P2 |
| Format Type | : | |
| Number of Pages | : | 461 Pages |
| Publish Date | : | 2013-05-23 |
| Language | : | English |
DESCRIPTION:
Good introduction of VBA for MS Excel. Disclaimer. The author provided me with a free copy of the book after he saw my review for another VBA book. For this review I actually typed in all the example code in this book. Error I found in the book have been all corrected in currently available revision of the book.Microsoft Excel is arguably the most used computer application program in the corporate world. People use it all
Start programming in VBA for Microsoft Excel 2013 now and get a fast yet solid foundation in VBA programming as you work through a complete project from start to finish. Upon finishing the book, you will have created a complete, working project from start to finish.Chapter 1, Importing Data, starts by discussing a number of different ways to bring external data into Excel and has you work through several examples. The project itself can also be downloaded from the Abstractive Media website.Inside you will find everything you need to start manipulating spreadsheet data using the VBA programming environment within Microsoft Excel 2013. The full code is included and can be copied and pasted directly from the book into your project. You will also be importing the film list data that will be used throughout the project, the source file for which can be downloaded from the book's Resources section.Chapter 2, Add-Ins and Macros, introduces both of these and guides you through the creation of each.Chapter 3, Preparing for Development, shows you how to access the Developer tab in Excel.C