Excel VBA guides and books reviews and listing

If you need Excel VBA guides for beginners or advanced users to automate your Excel spreadsheets, please find out the book from our listing. These books are written by VBA programming professionals, and could be divided into some steps: VBA for beginners, start level of Excel VBA knowledge, advanced level and high level of professionals. These books have various prices range, from $0.01 to $200+. Most of Excel VBA books have Used condition to buy, and their price could be lower than new one more than 70-80%. So, if you need powerful Excel VBA guidance, please select the appropriate book from this listing. Additionally, these books have great readers reviews, so their experience are very useful. Microsoft Excel VBA is growing many years and you could find books for Microsoft Excel 2003 VBA - that is OK, main VBA programming features, syntax, object model are the same as in MS Excel 2003 or even in Excel 1997 version, when MS Office 1997 was released (due to Wikipedia, MS Office 1997 was released in November, 1996). There are some books for practical engineering, economical, chemical engineering tasks. If you need electronic version of these books, please switch to Kindle tab on the book's description page.
TitleDescriptionCoverPrice
Mastering Excel Macros: Introduction (Book 1) Kindle EditionExcel macros. Everybody wants to learn them. You're not a programmer though. How is a non technical user going to learn how to program? You do want to use macros to make your work easier but are you really going to sit down with a huge programming textbook and work your way through every. single. boring. page? Like most people, you'll start with great enthusiasm and vigor but after a few chapters, the novelty wears off. It gets boring.

I'm going to try and change that and make learning macro programming entertaining and accessible to non-techies. First of all, programming Excel macros is a huge topic. Let's eat the elephant one bite at a time. Instead of sitting down with a dry, heavy text, you will read very focused, to the point topics. You can then immediately use what you learned in the real world.

This is the first lesson in the series. You will learn what macros are, how to access them, a tiny bit of programming theory (just so you have a clue as to what's going on) and how to record macros. As with all my other lessons, this one has a follow along workbook that you can use to work through the exercises.

The images in the lessons are based on Excel 2013 for Windows.
Free For Kindle Users
Excel VBA in Easy StepsLearning to program in Excel VBA is easy! The Visual Basic programming language is available and waiting in Excel itself - ready to be used. This book will help you utilize the full power of Excel to write and extend macros. It will also allow you to learn to program in Visual Basic - without the expense of buying the Visual Basic software! Its easy, step-by-step, colourful, illustrated approach is ideal for complete beginners or users a little daunted by advanced VBA books. Increase productivity and efficiency with this excellent guide.$0.01 (Used)
Excel VBA 24-Hour Trainer 1st EditionIncrease your productivity and save time and effort with Excel VBA

This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible.

Excel VBA 24-Hour Trainer:

Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays
Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions
Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls
Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL
Demonstrates how to interact with other Office Applications from Excel, including Word, Access®, PowerPoint®, and Outlook®

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.
$0.98 (Used)
Mastering Excel 2003 Programming with VBA 1st EditionCreate powerful business applications with Excel 2003. Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers. Written by a professional with nearly a decade of experience producing Excel/VBA solutions, "Mastering Excel 2003 Programming with VBA" conveys the precise knowledge and techniques you need to be highly productive. You'll master the most critical Excel objects and development practices necessary to create a complete solution, including working with XML data, Smart Document technology, and database integration with ADO. And you can readily apply the practical advice and reusable code examples to your own projects. In his friendly style, author Steven Hansen makes the information easy to grasp and entertaining to read, and he does not shy away from challenging material. You'll learn all about: ramping up with VBA Debugging tools and tactics that work; mastering the Excel Object Model Developing class modules; customizing Excel UserForms; integrating Excel with other applications; incorporating text files in your solution; coding solutions that leverage a database; using XML in Excel; designing user-friendly toolbars and menus; building Excel 2003 Smart Documents; and, deploying your solution.$2.35 (Used)
Introduction To Manipulating Data Programmatically In Microsoft Excel With VBA Kindle EditionStart 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. The full code is included and can be copied and pasted directly from the book into your project. 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. 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. 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.

Chapter 4, Setting Up the Projects, teaches you how to set up your projects within Excel before starting to write code.

Chapter 5, Creating a List of Genres Programmatically, walks you through writing the code to locate the different genres found within the film list data and to save them to a collection.

Chapter 6, Creating and Populating Worksheets Programmatically, uses code to copy the films of each particular genre out of the original film list and place them within a new worksheet for that genre.

Chapter 7, Summarizing Data Programmatically, looks at presenting totals and percentages in a separate worksheet.

Chapter 8, Creating Charts Programmatically, uses the summary data gathered in the previous chapter to create a chart in the Summary worksheet.

Chapter 9, Formatting Programmatically, focuses on the presentation of the data, increasing readability for the end user.

Chapter 10, Distributing the Add-In, wraps up development by talking about distributing your Add-In and enabling its functionality.

The next two sections contain full code listings for the two project files created in the book.

At the end of the book you will find the Resources section which acts as a central repository for all of the files/resources that you will need as you work through the book's projects.

Get your quick start down the path to Excel programming with VBA now!
$2.99 For Kindle Users
41 Success Habits for Creating Excel Macros Kindle EditionIf you create Excel Macros in your job there are 3 important ways you can improve

1.Build the Macros in less time
2.Make the Macros run faster
3.Reduce the number of errors in the Macros

This book can help you achieve all three. It contains 41 time tested principles for improving the Macros you create. These techniques are used by the top professionals to create top quality VBA code. If you adopt these principles as your habits you will improve you Macro skills in a very short time. Most of the habits are simple to use and you will see the results immediately.

They include
1.Ways to check a file exists before you try and open it
2.Turning off certain Excel functionality so you Macros run much faster
3.An easy method for deciding which of the 7 VBA Loops is best to use
4.How to read a large set of data into an Array using just one line of code!
5.A simple logger you can use right now to record users and errors
6.Why Debug.Assert is worth its weight in solid gold

and much much more.
$2.99 For Kindle Users
Microsoft Excel VBA Codes Are Fun, Simple, and Easy to Learn In One Hour or Less: VBA for Students, Parents, and Professionals (First Edition) Kindle EditionThis book is the first of three books to come in a series that is dedicated to making VBA in Microsoft Excel less scary for regular, everyday people. This book is packed with pictorial examples to ensure that your learning experience is fast, quick, easy, and extremely enjoyable. In this edition, you'll learn to use these Microsoft Excel VBA objects, statements, properties, features, and formulas: Font, Size, Color, Border, Range, Interior, InputBox, MsgBox, Offset, IF, With , Sub, Private Sub, Variables, Arrays, Image, Dim, ActiveX, Button, Transpose, Copy, Save, Close, Value, Selection, ActiveCell, ColorIndex, BorderAround, AddComment, and more.

The Hypertext Markup Language (HTML) and Cascading Style Sheet (CSS) codes were manually edited within the zip file on September 8, 2013, before converting the book to epub and mobi formats; the revisions include moving the left margin of the "array" list item "[5]" in the "Introduction to VBA" chapter to 0.25 inches; the variables under it were also indented to 0.50 inches. The last change that was made to this book was to restore it to full-color text by restoring its original CSS properties.
$2.99 For Kindle Users
Excel VBA Programming For Dummies 1st EditionHaving Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50" flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and, much more. This guide is not for rank Excel amateurs. It's for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you're an intermediate or advanced Excel user, "Excel VBA For Dummies" helps you take your skills (and your spreadsheets) to the next level.It includes: an introduction to the VBA language; a hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it; the essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder; the essential VBA language elements, including comments, variables and constants, and labels; working with Range objects and discovering useful Range objective properties and methods; using VBA and worksheet functions, including a list and examples; programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop; and, automatic procedures and Workbook events, including a table and event-handler procedures. This title also includes: error-handling and bug extermination techniques, and using the Excel debugging tools; creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks; customizing the Excel toolbars; using VBA code to modify the Excel menu system; creating worksheet functions and working with various types of arguments; and, creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities.Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including "Excel 2003 Bible" and "Excel 2003 Power Programming with VBA". While this guide includes tons of examples and screenshots, Walkenbach knows there's no substitute for hands-on learning. The book is complete with a dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes and information to help you make the most of Excel's built-in Help system so you can find out other stuff you may need to know. What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it's a very big accomplishment.$4.99 (Used)
Excel 2003 Power Programming with VBA (Book & CD-ROM) 1st EditionEverything you need to know about:
* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* Incorporating event-handling and interactions with other applications
* Building user-friendly toolbars, menus, and help systems
* Manipulating files and Visual Basic components
* Understanding class modules
* Managing compatibility issues

Feel the power of VBA and Excel

No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away.

CD-ROM Includes
* Trial version of the author's award-winning Power Utility Pak
* Over one hundred example Excel workbooks from the book
$5.27 (Used)
Excel Programming: Your visual blueprint for creating interactive spreadsheets 3rd EditionA great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics!

This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons of usable code and sample macros that you can put to use instantly.

Explains step-by-step how to automate Excel, the world's leading spreadsheet application from Microsoft
Covers most tasks in two-page spreads -- no flipping back and forth required!
Teaches you over 130 tasks, including how to record macros, program in Visual Basic for Applications (VBA), debug code, automate charts, interface with other macros, automate functions -- all in an easy-to-follow visual format
Uses clear, step-by-step, numbered instruction and lots of graphics and screenshots -- perfect for visual learners!
Helps you maximize your productivity with practical examples, tips, and advice

Harness everything that Excel has to offer with this friendly, practical, visual guide.
$5.30 (Used)
Excel Macro Mastery - How You Can Write VBA Like a Professional in 15 Simple Steps Kindle EditionFINALLY! A Way To Create Excel Macros That Won’t Burst Your Brain.

Because if you think Excel VBA programmers are smarter or more gifted than you, then you’re mistaken. Truth is, they use dozens of proven programming principles…. little-known techniques that are completely unknown to most Excel users.

What are these principles? How can you learn them? And how can you use them to create your own Macros?

In 15 Simple Steps, Paul M Kelly teaches you dozens of well-guarded secrets that he learned during his 20+ years as a software developer, including

* How to Easily Write to Cells with one line of code – It’s not hard to do once you know the secret

* How To Quickly Create Solid Excel Macros - Tons of examples you can steal for yourself.

* The In Built VBA Tools That Help You Easily Find Bugs – If you think you would make a good detective then you may really enjoy this

* How to Solve Any Common Error in Seconds Using the Translator Table – An easy to read error list that should have been written years ago

* Why You Only Need ONE Type of Loop in VBA – Learn which of the 7 Loops you will use 99% of the time

* Why Using Collections Can Save Hundreds of lines – It’s hard not to do once you know the secret

* 3 Key Elements of Excel Macros – The three elements that everyone should know

* How to Easily Format any Cell – Changing a cells font, color, format is so simple you could do it now.

* How To Easily Open Any Workbook – I provide the code, You can use it everywhere!

* This Evil Workbook type should never be used – Do You Use It?

* What Steps You Should Take To PROTECT Yourself When Building a Real World Macro – Are You Doing Them?
$5.99 For Kindle Users
Excel Programming Weekend Crash Course 1st Edition
Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X"
Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes
Applicable to Excel 2000, Excel 2002, and the latest release, Excel 2003
Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects
A how-to guide to using Excel's programmability to create custom data-processing and analysis solutions
Covers security, debugging, and error handling
Companion Web site includes sample files, projects, and test enginewith self-assessment exam
$6.26 (Used)
Excel 2016 For Dummies Video Training HD1. Overview
In this episode, Host Peter VanRysdam and Excel guru Ronnie Wong will introduce you to Microsoft Excel 2016 and let you know what you can expect to learn from this series.
More Purchase Options
2. Discover the Interface
Before you can really get started with Microsoft Excel 2016, you need to get a lay of the land. In this episode, Ronnie and Peter review the interface of Excel 2016 including the ribbon, contextual menus, and navigating within a worksheet.
More Purchase Options
3. Create a Spreadsheet
Not all data in Excel 2016 is created equally. Excel treats numbers like dates, currencies, and formulas different ways. In this episode, Ronnie and Peter show not only how to input information in to a spreadsheet, but how to tell excel what type of data it is.
More Purchase Options
4. Create a Basic Formula
The real power within Microsoft Excel 2016 lies in formulas, which allow you to perform complex calculations instantaneously. Ronnie and Peter show you the different ways to create formulas, as well as how to use the formulas built in to Excel.
More Purchase Options
5. Format in Excel
With the ability to hold seemingly endless amounts of data across thousands of rows and columns, working within Excel 2016 can be intimidating. Ronnie and Peter use this episode to break down the available formatting tools within Excel that allow you to style and organize your data.
More Purchase Options
6. Print Excel Data
Printing a worksheet in Excel 2016 is not as simple as printing a document. In this episode, Ronnie and Peter not only show you the available print options, but offer tips for formatting your content so it prints in an easy-to-understand format.
More Purchase Options
7. Organize a Workbook
It's important to understand the difference between a workbook and worksheets in Excel 2016, as well as how they can interact with one another. In this episode, Ronnie and Peter detail how to create and organize different worksheets while providing tips for sharing data across them.
More Purchase Options
8. Adding Charts
Suffering from data overload? Charts are a great way to showcase your information while providing visual interest. Ronnie and Peter review the different types of charts and go through the steps to set them up in Excel 2016.
More Purchase Options
9. Automate Tasks with Macros
Making changes to a sheet is one thing, but updating several at once can be time consuming. In this episode, Ronnie and Peter show you how macros can easily automate repetitive tasks to save you time and frustration.
More Purchase Options
10. Customizing Excel
Don't like the way the contextual ribbons are laid out or the default fonts in Excel 2016? Well Ronnie and Peter will show you how you can customize those and other features to tailor your experience to your liking.
More Purchase Options
11. Overcoming Obstacles in Excel
Getting stuck in Excel 2016? Before you chuck your computer out the window, take a look at some simple solutions to the most common issues users face while using the program.
$9.99
Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access Kindle EditionFor any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures provided. Tasks covered include how to run several mail merges at once, removing duplicates from data, and saving email attachments.$9.99 For Kindle Users
Mastering VBA 2nd EditionVBA is used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. Easily accessible by novice programmers, VBA is also powerful enough for IT professionals who need to create specialized business applications, generating wide interest. Completely revised for the new versions of the language and the Office suite, this book is the most up-to-date VBA guide on the market. It includes what everyone, from power users to system administrators and professional developers, needs to know. It covers all Office products in depth.$10.44 (Used)
Excel VBA Programming For Dummies 3rd EditionTake control of your spreadsheets and use VBA to create your own custom Excel applications

Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.

Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor
Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions
Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more
Zeroes in on creating custom dialog boxes, toolbars, and menus

Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition.
$10.49
Microsoft Excel 2000 Power Programming with VBA 1st EditionWith the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000 -- from UserForms to class modules.$10.55 (Used)
VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel (with VBA Program CD-ROM) 2nd EditionLearn more effective modeling techniques than ever before! VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS USING MICROSOFT EXCEL shows you the easy way to automate methods and models and create special applications. You'll learn sophisticated techniques through a simple and clean interface, so there's no more long nights of trying to make it work. And because it works with Microsoft Excel, you'll be saving time while the program crunches all the numbers.$11.25 (Used)
Excel VBA: A Beginners' GuideExcel VBA is very helpful for you to do your routine task, create your own function, reduce the manual effort and increase your productivity. With the help of VBA you can customize and manipulate data present in the excel sheet as you want. This book will be very helpful and comes in handy for the beginners who don’t have any programming knowledge. The ultimate aim of this book is to turns the reader to think like an Experienced VBA programmer. All the topics in this book are elaborated in simple manner for easy understanding. Each and every topic in this book is covered with detailed illustrations followed by output. What you will learn in this book 1) Introduction to Excel VBA- 2) Declaring Variables 3) Working with Ranges 4) If…Else Statements 5) Select Case Statements 6) For Next Statements 7) Do Loops 8) Operators in VBA 9) Understanding the VB Editor 10) Function Procedures 11) MsgBox and InputBox Functions 12) String Functions 13) Information Functions 14) Working with Internet Explorer$11.99
EXCEL 2007 MACROS MADE EASY (Made Easy Series) Kindle Edition Get beyond the basics with Excel 2007 macros
Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. You'll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.
Record and edit macros
Create and debug macros in VBA
Save macros to the Personal Macro Workbook or other workbooks
Create VBA subroutines and functions
Develop interactive macros
Format cells using macros
Create variables and arrays
Apply logic to macros with If/Then/Else routines
Use loops to process data
Add controls to your worksheets
$13.19 For Kindle Users
Mastering VBA for Microsoft Office 2007 2nd EditionEven if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.$15.98 (Used)
VBA For Excel Made Simple (Made Simple Programming) Kindle EditionThis book provides an introduction to VBA for Excel for new users. It covers basic concepts of VBA and of macro programming, and takes the reader through the process of constructing interactive working applications.

Features which make it particularly suitable for new and non-technical users are:
* step-by-step approach
* avoidance of jargon
* clear explanation of all new concepts, symbols and objects
* emphasis on correct use of VBA development environment
* plentiful examples and the use of complete programs rather than disconnected fragments.
$16.17 For Kindle Users
Excel 2002 VBA: Programmers ReferenceWhat is this book about?

VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment.

Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support.

Based on the successful content and format of Excel 2000 VBA Programmer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community.

What does this book cover?

The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real-world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models.

Here are just a few of the things you'll learn in this edition:

The entire Excel Object Model and the Common Office Object Model
Working with PivotTables
Accessing and manipulating data sources from Excel with ADO
Programming the Visual Basic Editor (VBE)
New features in Excel 2002, SmartTags, XML, and the Web
Expanded references for Excel versions 97, 2000, and 2002

Who is this book for?

This book not only caters for beginner- and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.
$18.00 (Used)
Excel VBA 2013: For Non-ProgrammersMicrosoft Excel has, over the years, become the greatest software in the field of electronic worksheets. Its strength is that it meets the demands of huge numbers of users worldwide. Nonetheless - despite the advancement and expanding use of this software - there is ever-increasing demand from the end users; much of which can only be solved by VBA programming (Visual Basic for Applications). Therefore, Excel VBA – In Everyday Language was written in order to provide a response to the growing demand for the advanced capabilities of Microsoft Excel. This book was written: For the non-programmers among us who have to create the same reports in Microsoft Excel time and again, and would like to automate the process. For people who wish to develop forms, screens and machines for data management within their organization. For individuals who wish to turn Microsoft Excel into a powerful tool in their daily work. During the writing process I tried to visualize Microsoft Excel software and the VB editor through the eyes of the end users; people who may not have programming background, but aspire to reap the utmost from the program. For this reason the book, based on many years' of experience in programming and training, has been written in everyday language, using as few technical terms as possible, to make for easy reading. My goal, when writing this book, was to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training. For this purpose there are files of exercises accompanying the book. These may be downloaded from this link. The exercise files are in .xls format, allowing the end users to use either the Ribbon Versions (2007 and higher) or other older versions of Microsoft Excel. This new edition has undergone extensive processing and addresses Microsoft Excel 2010/2013 users, along with explanations for anyone using the older versions (2003 and 2007). Therefore, wherever there is a significant difference between Excel 2010/2013 and the old versions, explanations are provided in full. While reading the book and using the practice files, you will know to: Add the Developer Tap Change Excel's security, Including trusted locations Enter the VBE (Visual Basic Editor) Change the VBE structure Record an absolute macro Record a relative macro Improve your recorded macro Apply to ranges (Cells, ranges, columns, rows, sheets, offset) Manage files and folders Use Variables Use the 'With' command Manipulate strings Calculate Date and Time Interact with the user (Msgbox and Inputbox) Use conditions (IF) Loop through data (Do loops, For loops) Create your own functions (UDF) Create an Event macro Handle Errors You will also learn some cool tips and tricks, and get some useful codes$19.71
Excel Programming with VBA StarterGet started with programming in Excel using Visual Basic for Applications (VBA)

Overview

Extend and enhance your Excel spreadsheets using the power of Macros and VBA programming
Get to grips with the VBA language to create professional spreadsheets.
Follow practical examples to common problems that you will find yourself using time and time again.

In Detail

Do you have repetitive tasks that you would like to get rid of for good? Would you like to integrate Office Applications in order to streamline some of your tasks? Then look no further. This compact book will provide you with the knowledge to get your VBA programming off the ground and up to a comfortable cruising speed.

"Excel Programming with VBA Starter" was born out of the need to have a short, but yet all-encompassing book that would give you a solid foundation in programming with Visual Basic for Applications. This book will enable you to harness the power of VBA in Excel and put it to good use throughout the course of your working day.

Can't find properties and methods of an object? Don't know what a property, method or object is? Covering simple and advanced topics, create powerful, reusable examples such as IO, picking files from within Excel and automatically attaching them to e-mails. Learn and use the concept of encapsulation to condense code into bite-size methods to be easily accessed from within your projects, plus much more.

What you will learn from this book

Get started with recording and play macros
Learn to use sub routines, with and without arguments
Create user-defined functions (UDFs)
Work with loops and effectively debug your code
Use UDFs to describe arguments, create custom categories and more
Reference external libraries and use them in your project
Program interaction and sharing with other Office Applications
Learn to work with enumeration
Use advanced features and work with Windows APIs
Create classes and hide away complex code

Approach

JS#12 This is a starter guide, covering the basics you need to get up and running as quickly as possible.

Who this book is written for

This book is written for users of Excel who want to speed up and streamline normally arduous tasks for maximum productivity.
$19.99
Mastering Excel Macros (8 Book Series) Kindle EditionExcel macros. Everybody wants to learn them. You're not a programmer though. How is a non technical user going to learn how to program? You do want to use macros to make your work easier but are you really going to sit down with a huge programming textbook and work your way through every. single. boring. page? Like most people, you'll start with great enthusiasm and vigor but after a few chapters, the novelty wears off. It gets boring.

I'm going to try and change that and make learning macro programming entertaining and accessible to non-techies. First of all, programming Excel macros is a huge topic. Let's eat the elephant one bite at a time. Instead of sitting down with a dry, heavy text, you will read very focused, to the point topics. You can then immediately use what you learned in the real world.

This is the first lesson in the series. You will learn what macros are, how to access them, a tiny bit of programming theory (just so you have a clue as to what's going on) and how to record macros. As with all my other lessons, this one has a follow along workbook that you can use to work through the exercises.

The images in the lessons are based on Excel 2013 for Windows.
$20.93 For Kindle Users
Excel 2007 VBA Programmer's Reference 1st EditionThis book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language.

The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help.

The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.

The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).
$21.22
Excel Macros For Dummies 1st EditionReady-made Excel macros that will streamline your workflow

Excel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find the most effective Excel macros for solving common problems, and explanations of why and where to use each one, plus invaluable guidance and step-by-step instruction for applying them effectively. Learn how to customize your applications to look and work exactly the way you want them to, with simple, friendly walk-throughs that directly apply to real-world tasks. Follow it through from start to finish, or quickly look up problems as they occur; the book's clear layout and organization makes it an irreplaceable desk reference, and all macro code is available for download from the companion website.

Microsoft Excel is the world's leading spreadsheet application, and it supports VBA macros that allow you to customize the program and automate many common tasks. This book helps you take advantage of macros to get more done, and get it done better.

Grasp the fundamentals of VBA and macros
Work with workbooks, worksheets, and ranges
Clean data, automate reporting, and send email from Excel
Use tips and tricks that streamline your workflow

If you have an Excel problem, there's a macro to solve it. You don't need to be a programmer, and you don't need to spend months learning code. Excel Macros For Dummies gives you the "recipes" you need, and the knowledge to apply them effectively.
$21.74
Excel 2007 VBA Programming For Dummies 1st EditionStep-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to

Grasp essential programming concepts
Use the Visual Basic Editor
Navigate the new Excel user interface
Communicate with your users
Deal with errors and bugs
$22.08
Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)Great book to start to learn Excel VBA$23.86 (Used)
Excel 2010 Power Programming with VBA 1st EditionAll the methods and tools you need to successfully program with Excel

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.

Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else
Includes a CD with templates and worksheets from the book

This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
$24.73
Microsoft Excel 2013 Power Programming with VBAMicrosoft excel 2013 power programming with vba is a work that aims to maximise the user's experience of excel 2013 with the utilisation of vba application development. The version of excel 2013 is feature-rich with many updated applications, enhanced power, and modern capabilities. Hence, the author, who is arguably one of the most well known in his field, returned with a book to explain all the tips and tricks that go with the new excel.the book is a comprehensive guide, and the anthropomorphic "mr. Spreadsheet" takes the readers through all the features. Maximising the user's excel experience with the help of professional spreadsheet application development tips is one of the key aims of mr. Spreadsheet. With this book's methods and tools, the user should have a fair idea of all the ways to use excel to program.microsoft excel 2013 power programming with vba is a comprehensive work with a complete introduction to visual basic for applications and is fully up to date with excel's latest features. It aims to be an essential guide containing all the tips, tricks, and methods necessary to expand on excel's capabilities using vba. Microsoft excel 2013 power programming with vba was published by wiley india pvt. Ltd in 2013 and is available as a paperback. Key features: the book provides unique tips and tricks to utilise vba in excel that won't be available in any other material.offers an analysis of excel application development and a complete introduction to vba.contains the author's award winning utility pak to help excel skills and use collaboration tools with it for the reader.$25.92
Excel 2007 Power Programming with VBA 1st Edition This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
Includes a valuable CD-ROM with templates and worksheets from the book
$27.95
Excel VBA Programming For Dummies 4th EditionTake your data analysis and Excel programming skills to new heights

In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more.

With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all!

Provides step-by-step instructions for creating VBA macros to maximize productivity
Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want
Fully updated for Excel 2016
All sample programs, VBA code, and worksheets are available at dummies.com

If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.
$28.18
VBA and Macros for Microsoft Office Excel 2007 1st EditionDevelop your Excel macro programming skills using VBA instantly with proven techniques

Automate Reports

Handle Errors

Master Pivot Tables

Produce Charts

Build User-Defined Functions

Migrate to Excel 2007

Query Web Data

Build Dialog Boxes

Use Data Visualizations

Automate Word

You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

Learn VBA syntax as easy-to-understand English
Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters
Save hours per week by automating redundant tasks
Create applications built on top of Excel with custom dialog boxes
Automatically produce hundreds of Excel reports in seconds
Understand how changes in Excel 2007 impact your VBA macros
$28.71
VBA and Macros: Microsoft Excel 2010 (MrExcel Library) 1st EditionAUTOMATE REPORTS

BUILD FUNCTIONS

VISUALIZE DATA

WRITE FAST, RELIABLE SCRIPTS

Microsoft Excel 2010

VBA AND MACROS:

SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS!

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.

Work efficiently with ranges, cells, and R1C1-style formulas

Build super-fast applications with arrays

Customize the Excel 2010 Ribbon to run your macros

Write Excel 2010 VBA code that works on older versions of Excel

Create custom dialog boxes to collect information from your users

Use error handling to make your VBA scripts more resilient

Use Web queries to import data from virtually any online source

Master advanced techniques such as classes and collections

Use Excel VBA to control other Office programs…even control Windows itself,

via the Windows API

Create add-ins to share or sell your programs

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

Dramatically increase your productivity—saving you 50 hours a year or more

Present proven, creative strategies for solving real-world problems

Show you how to get great results, no matter how much data you have

Help you avoid critical mistakes that even experienced users make
$29.79
EXCEL 2016 Programming By Example: with VBA, XML, and ASP Kindle EditionUpdated for Excel 2016 and based on the bestselling editions from previous versions, Microsoft Excel 2016 Programming by Example with VBA, XML and ASP is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous, illustrated, hands-on exercises. More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using Classic ASP pages to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. The book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and guides you through programming advanced Excel features such as PivotTables, PivotCharts, and the Ribbon interface. Companion files include all of the source code and supplemental files for the Hands-On exercises and custom projects(available for download from the publisher with Amazon order number by writing to info@merclearning.com.)

FEATURES
+Contains 28 chapters loaded with illustrated "Hands-On" exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code, how to test it and then run it.
+Companion files include all of the source code and supplemental files for the Hands-On exercises and custom projects(available for download from the publisher with Amazon order number by writing to info@merclearning.com.)
+Takes you from introductory topics--including recording and editing macros, using variables, and constants, writing subroutines/functions, conditional statements, and various methods of coding loops to repeat actions--to intermediate and advanced topics that include working with collections, class modules, arrays, file and database access, custom forms, error handling and debugging.
+Includes comprehensive coverage of native file handling in VBA, Windows Scripting Host (WSH), and low-level File Access.
+Demonstrates how to interact with Microsoft Access databases using both ADO and DAO Object Libraries to access and manipulate data.
+Includes chapters on programming charts, PivotTables, dialog boxes, custom forms, the Ribbon, Backstage View, context/shortcut menu customizations, as well as proper use of event procedures and callbacks.
+Provides a quick Hands-On introduction to the data analysis and transformation process using the new Excel 2016 Get & Transform feature and the M language formulas.
+Provides a practical coverage of using Web queries, HTML, XML, and VBScript in Classic ASP to retrieve and publish Excel data to the Web.

On The Companion Files!
(Files on the companion disc or available for download from the publisher with Amazon order number by writing to info@merclearning.com.)
+All source code and supplemental files for the Hands-On exercises and custom projects
+All images from the text (including 4-color screenshots)
$29.95 For Kindle Users
Excel 2013 Power Programming with VBA 1st EditionMaximize your Excel 2013 experience using VBA application development

The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

Offers an analysis of Excel application development and a complete introduction to VBA
Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small
Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills
Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else

Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.
$31.04
Excel 2013 VBA and Macros (MrExcel Library) 1st EditionSAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS!

Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe
even weeks. Then, learn how to make Excel do things you thought were simply impossible! You’ll discover macro
techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful
and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues
can understand and act on it…how to capture data from anywhere, and use it anywhere…how to automate
Excel 2013’s most valuable new features. Mastering advanced Excel macros has never been easier. You’ll find
simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus
examples, macros, and solutions–straight from MrExcel.

Get started fast with Excel 2013 macro development

Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models

Work efficiently with ranges, cells, and R1C1-style formulas

Build super-fast applications with arrays

Write Excel 2013 VBA code that works on older versions of Excel

Create custom dialog boxes to collect information from your users

Use error handling to make your macros more resilient

Use web queries and new web service functions to integrate data from anywhere

Master advanced techniques such as classes, collections, and custom functions

Build sophisticated data mining and business analysis applications

Read and write to both Access and SQL Server databases

Control other Office programs–and even control Windows itself

Start writing Excel Apps similar to those in the Excel App Store

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks
and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen,
Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

Dramatically increase your productivity–saving you 50 hours a year or more

Present proven, creative strategies for solving real-world problems

Show you how to get great results, no matter how much data you have

Help you avoid critical mistakes that even experienced users make
$32.95
Pro Excel 2007 VBA (Expert's Voice in Excel VBA) 1st ed. EditionThis is a professionals’ guide to understanding and implementing the key principles and techniques of programming Microsoft Office Excel 2007. Automating complex spreadsheets, streamlining time-intensive work processes, gaining the competitive edge, and making more money for your businesses: these are all reasons to take Excel to the next level. This book teaches how to do just that, with the author using his own real-life experience to develop your understanding to this professional level. The text teaches the most efficient way to create complex and feature rich VBA code, exposing all the new features and capabilities that make Excel 2007 so exciting.$33.20
Excel VBA 24-Hour Trainer 2nd EditionMaster VBA automation quickly and easily to get more out of Excel

Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios.

This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice.

Program Excel's newest chart and pivot table object models
Manipulate the user interface to customize the look and feel of a project
Utilize message boxes, input boxes, and loops to yield customized logical results
Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel

If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.
$33.88
Mastering VBA for Microsoft Office 2013 2nd EditionA unique, comprehensive guide to creating custom apps with VBA

Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access.

Covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers
Explores recording macros and getting started with VBA; learning how to work with VBA; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security
Anchors the content with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access

Covering VBA for the entire suite of Office 2013 applications, Mastering VBA for Microsoft Office 2013 is mandatory reading.
$33.98
VB & VBA in a Nutshell: The Language (In a Nutshell (O'Reilly)) 1st EditionThe online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And inVB & VBA in a Nutshell: The Language, it finally is available.The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information:

Its syntax, using standard code conventions
Differences in the operation of the keyword in a macro environment (e.g., in Office) and in Visual Basic, if there are any
A list of arguments accepted by the function or procedure, if any
A description of the data type returned by a function
The finer points of a keyword's usage that are often omitted from or blurred over by the documentation
Tips and gotchas that include undocumented behaviors and practical applications for particular language elements -- a section particularly invaluable for diagnosing or avoiding potential programming problems
A brief, nonobvious example that illustrates the use of the keyword

Also included in VB & VBA in a Nutshell: The Language is a brief overview of the VB/VBA language, including:

Basic VBA programming concepts, such as its data types and its support for variables, constants, and arrays
Error handling in VBA applications
Object programming with VBA
Using VBA with particular applications. Excel and Project are utilized to show how to work with an application's integrated development environment and to take advantage of its object model Regardless of how much experience you have programming with VBA, this is the book you'll pick up time and time again both as your standard reference guide and as a tool for troubleshooting and identifying programming problems.

VB & VBA in a Nutshell: The Language is the definitive reference for Visual Basic and VBA developers.
$33.99
Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 2nd Edition Use Excel with VBA to obtain high precision numerical solutions to complex engineering problems.
Create custom functions, macros, and user-forms with VBA to boost your Excel workbooks.
Validate input, collaborate, and document results in Excel.
Exploit Excel's built-in capabilities for numerical analysis and graphical presentation.
Enhance Excel with a companion Suite of more than 120 powerful VBA macros for numerical analysis.
Learn applied numerical methods from over 200 working Excel Example Files from the book. All of the Excel workbooks used to create the book's section illustrations (Sn.xls) and chapter examples (Ex.xls) are available for download in the Examples folder.
Find roots to linear systems, eigenproblems, and nonlinear systems of equations in Excel using the Solver and advanced solution methods like Newton's method of continuation.
Evaluate derivatives numerically (up to order 5 using Ridder's algorithm) of complicated worksheet functions for root finding, optimization, and sensitivity analysis.
Optimize mathematical models of multidimensional objective functions using Excel's Solver and VBA macros with Powell's method, Downhill Simplex, and Luus-Jaakola or Firefly for multimodal problems.

Propagate uncertainty in design calculations using bootstrapping, truncated Taylor Series linearized models, and Monte Carlo methods with latin hypercube sampling.
Model data in Excel with multivariable linear and nonlinear least-squares regression with Excel add-ins, the Solver, optimization macros, Jack Knife, Gauss-Newton or Levenberg-Marquardt methods with verification, validation, and uncertainty analysis.
Interpolate single variable and bivariate data sets in Excel worksheets using lines, polynomials, rational functions, cubic splines, and Hermite constrained splines.
Get high precision numerical solutions in Excel for Calculus problems involving: Single and multiple integrals, Systems of ordinary differential equations, Second-order Boundary-value problems, and Partial differential equations.
Use Monte Carlo methods in Excel for uncertainty and risk analysis, optimization, and integration.
Sharpen your Excel skills with Practice Problems (PP.pdf) located in chapter folders.
Simplify your work with user-defined functions that extend unit conversion, large cycle pseudo-random number generation, outlier tests, and yx graphing of worksheet functions and data.
$34.97
Mastering VBA for Office 2010 1st EditionA comprehensive guide to the language used to customize Microsoft Office

Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs.

Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office
Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content
Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security

Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.
$36.68
Programming Excel with VBA and .NET 1st EditionWhy program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.

The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).

This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages.

With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.
$38.11
Excel 2007 VBA Programming With XML And ASP (Wordware Applications Library)Excel 2007 Programming by Example with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to accss and display data, this book takes you on a progrmming journey that will change the way you work with Excel. Learn how to automate spreadsheet tasks with macros; write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon; handle errors and debug programs; create hyperlinks and publish HTML files. Retrieve data from the web directly into Excel; develop and manipulate smart tags using XML.$38.15
Microsoft® Excel® 2010 Programming By Example: with VBA, XML, and ASP (Computer Science)Microsoft Excel 2010 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed.$39.61
Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP (Computer Science)This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web. Microsoft Excel 2013 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. The chapters are loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed.

Features:
Explores in great detail the latest version of Excel and all of its features.
Covers recording and editing a macro and writing VBA code through working with XL documents and using ASP to display data on the Web.
Covers Office Web Apps.
$39.71
Excel VBA and Macros with MrExcel 1st EditionDVD includes:

7+ HOURS OF VIDEO INSTRUCTION
50 TIPS & TECHNIQUES
SKILLS YOU CAN LEARN IN Fifteen MINUTES OR LESS

In Excel VBA and Macros with MrExcel, renowned Excel instructor and author Bill Jelen (MrExcel) teaches all the skills you’ll need to automate virtually any routine task with Excel and build powerful Excel macros! This package brings together nearly eight hours hours of personalized, expert video training: 50 quick, practical video lessons that demonstrate all the skills you’ll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. You’ll learn one step at a time, at your own pace–using hands-on examples that reflect realistic challenges and showcase Excel’s remarkable capabilities. Along the way, Jelen will take you from the absolute basics through PivotTables and data filtering.

Excel VBA and Macros with MrExcel delivers the power of the best classroom training at a small fraction of the cost. If you don’t have time to read a huge book on Excel macros and scripting, this is exactly what you’ve been searching for!

For all serious Excel users: managers, financial pros, entrepreneurs, marketers, analysts, and more.

Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading technology experts.

LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions–you’ll learn key skills in as little as fifteen minutes!
Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
Follow along as your trainer shows you how to make the most of Excel’s macro recorder and its powerful VBA development environment!

Bill Jelen is called MrExcel for a reason! Nobody knows more about Excel macros and scripting–and nobody knows more about teaching these skills to working professionals! Thought you’d never write your own Excel macros and programs? Think again! You will…and you can start in just minutes!

Bill Jelen, known worldwide as MrExcel, presents live Excel seminars across the United States and appears in over 800 podcast episodes. His 20 Excel books include Special Edition Using Excel 2007 and VBA and Macros for Microsoft Excel. His website, MrExcel.com, answers 30,000 Excel questions per year.
$41.22
Excel 2003 VBA Programming With XML And ASPDesigned to provide non-programmers with a hands-on guide to automating their spreadsheets through the use of Visual Basic for Applications, Excel 2003 VBA Programming with XML and ASP also gives readers a wide range of VBA coverage and a thorough overview of a number of programming languages and techniques useful for working with Excel. Learn how to work with macros, write VBA procedures and functions, use object collections, and create classes; automate operations on files, folders, and other applications such as Microsoft Office Access; enhance the user interface through the use of dialog boxes; custom forms, menus, and toolbars; and event-driven programming; handle errors, debug procedures, and use e-mail in Excel; program features such as PivotTables, PivotCharts, lists, and SmartTags, and control the Visual Basic Editor; use Excel with a number of web technologies such as HTML, ASP, and XML.$43.95
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) 2nd EditionAs Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest Microsoft technologies.

–Gabhan Berry, Program Manager, Excel Programmability, Microsoft

The first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. The second edition expands both the depth and range. It shines because it takes every issue one step further than you expect. The book relies on the authors’ current, real-world experience to cover not only how a feature works, but also the practical implications of using it in professional work.

–Shauna Kelly, Director, Thendara Green

This book illustrates techniques that will result in well-designed, robust, and maintainable Excel-based applications. The authors’ advice comes from decades of solid experience of designing and building applications. The practicality of the methods is well illustrated by the example timesheet application that is developed step-by-step through the book. Every serious Excel developer should read this and learn from it. I did.

– Bill Manville, Application Developer, Bill Manville Associates

The Start-to-Finish Guide to Building State-of-the-Art Solutions with Excel 2007

In this book, four world-class Microsoft® Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors—three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)—show how to consistently make the right design decisions and make the most of Excel’s most powerful new features. Using their techniques,you can reduce development costs, time to market, and hassle—and build more effective, successful solutions.

Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, you’ll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If you’re a working developer, no other book on Excel programming offers you this much depth, insight, or value.

Design worksheets that will be more useful and reliable

Leverage built-in and application-specific add-ins

Construct applications that behave like independent Windows programs

Make the most of the new Ribbon user interface

Create cross-version applications that work with legacy versions of Excel

Utilize XML within Excel applications

Understand and use Windows API calls

Master VBA error handling, debugging, and performance optimization

Develop applications based on data stored in Access, SQL Server, and other databases

Build powerful visualization solutions with Excel charting engine

Learn how to work with VB.NET and leverage its IDE

Automate Microsoft Excel with VB.NET

Create managed COM add-ins for Microsoft Excel with VB.NET

Develop Excel solutions with Visual Studio Tools for Office (VSTO)

Integrate Excel with Web Services

Deploy applications more securely and efficiently
$44.47
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA 1st EditionEnterprise-Class Excel Programming, from Start to FinishFinally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications. This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companies--including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. effective worksheets, userforms, and other user interface elements
*Leveraging Excel's powerful data analysis features
*Creating sophisticated custom charts
*Handling errors, debugging applications, and optimizing performance
*Using class modules and interfaces to create custom objects
*Understanding Windows API calls: when to use them, and how to modify them
*Adding worksheet functions with C-based XLLs
*Programming with databases
*Controlling external applications from Excel
*Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
*Using XML to import and export data and communicate with Web services
*Providing help, securing, packaging and distributionCD-ROM INCLUDEDThe accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities.(c) Copyright Pearson Education. All rights reserved.
$45.36
Introduction to VBA for Excel (2nd Edition) 2nd EditionLearn to program and design user interfaces using Excel 2007.

This introductory text explains how to develop programs using VBA within the Microsoft Excel environment. The text does not assume any previous programming experience. The new edition has been revised to bring it up-to-date with the Office 2007 environment.
MARKET: For students and professionals in General Engineering or Computer Science fields.
$53.57
Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 3rd EditionThe latest 3rd edition expands on Practical Numerical Methods with more VBA to boost Excel's power for numerical modeling and analysis. Excel is used by collaborating engineers and scientists worldwide. Learn how to customize your Excel workbooks with VBA using many of the same numerical techniques found in specialized math software.
The refined Excel PNM3Suite macro-enabled workbook with over 170 VBA user-defined functions, macros & user forms for learning VBA and implementing advanced numerical techniques in Excel.
More than 200 practical examples and animation workbook files demonstrating the power of numerical methods. Customize the example files and macros to tackle your own problems using VBA in Excel.
Hundreds of practice problems for self-guided study to sharpen your Excel & VBA skills.

The first chapter sets the stage for problem solving with numerical methods. The next two chapters cover frequently overlooked features of Excel (2010, 2013 and later) and VBA for implementing numerical methods in Excel, as well as documenting results. The remaining chapters present powerful numerical techniques using Excel & VBA to find roots to algebraic equations, approximate derivatives, optimize, model data by least-squares regression & interpolation, analyze risk & uncertainty, solve integrals and ordinary & partial differential equations:

Numerical Methods & Mathematical Modeling: expert problem solving
Excel: Documentation, Graphing, Worksheet Functions, Input Validation & Formatting, What-if Analysis
VBA: Editor and objects, Function & Sub Procedures, Data Types, Structured Programming, Arithmetic and Worksheet Functions, Flow Control, Arrays, Communication, Message & Input Boxes, User Forms, Reading/Writing Files, Debugging, Unit Conversions
Linear Equations: Matrix Algebra, Gaussian Elimination and Crout Reduction with Pivoting, Thomas, Cholesky, Power, Jacobi, & Interpolation Methods for Eigenvalues & Eigenvectors, Jacobi & Gauss-Seidel Iteration, Relaxation
Taylor Series Analysis: Finite Difference Derivative Approximation, Richardson's Extrapolation, Ridder's algorithm, Sensitivity
Nonlinear Equations Root Finding: Methods of Bisection, Regula Falsi, Newton, Secant, Pade, Wegstein, Quasi-Newton, Aitkin/Steffensen, Homotopy, Bairstow (for polynomial roots), Goal Seek & Solver
Optimization: Solver, Luus-Jaakola, Quadratic, Golden Section, Powell, Downhill Simplex, Firefly, Constraints, Scaling & Sensitivity
Uncertainty & Risk Analysis: Bootstrap, Confidence Intervals, Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling
Least-squares Regression: Linear, Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Validation and Assessment, Uncertainty Analysis, Weighted Regression
Interpolation: Linear, Newton Divided Difference and Lagrange Polynomials, Rational, Bulirsh-Stoer Pade, Stineman, Cubic, B, Akima & Constrained Hermite Splines, Bivariate Interpolation
Integration: Graphical, Trapezoidal, Midpoint & transformation for Improper Integrals, Romberg, Adaptive Simpson & Gauss-Kronrod, Multiple Integrals by Simpson, Kronrod & Monte Carlo
Initial-value Problems: Single Step Euler & Backward Euler, Implicit Trapezoidal for Stiffness, Variable Step Runge-Kutta Cash-Karp, Dormand-Prince, Multi-step Adams-Bashforth-Moulton, Differential-Algebraic Systems
Boundary-value Problems & Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson
Review: Reference Tables of Excel & VBA Functions, User-defined Functions, Macros, User Forms
Primer on chemical reaction engineering
$65.95
Credit Risk Modeling using Excel and VBA 2nd EditionThis book provides practitioners and students with a hands-on introduction to
modern credit risk modeling. The authors begin each chapter with an accessible
presentation of a given methodology, before providing a step-by-step guide to
implementation methods in Excel and Visual Basic for Applications (VBA).
The book covers default probability estimation (scoring, structural models,
and transition matrices), correlation and portfolio analysis, validation, as well
as credit default swaps and structured finance. Several appendices and videos
increase ease of access.
The second edition includes new coverage of the important issue of how
parameter uncertainty can be dealt with in the estimation of portfolio risk, as
well as comprehensive new sections on the pricing of CDSs and CDOs, and
a chapter on predicting borrower-specific loss given default with regression
models. In all, the authors present a host of applications - many of which
go beyond standard Excel or VBA usages, for example, how to estimate logit
models with maximum likelihood, or how to quickly conduct large-scale Monte
Carlo simulations.
Clearly written with a multitude of practical examples, the new edition of
Credit Risk Modeling using Excel and VBA will prove an indispensible resource
for anyone working in, studying or researching this important field.
$72.00
Excel 2013 VBA (Visual Training series) Multimedia CDThis CD-ROM is not only an excellent learning tool to master VBA but also a gold mine for very powerful and useful macros. It has more than 1,200 PowerPoint slides that guide you through the learning process and comes with Excel files for you to work on as well as files that have the VBA code all done. Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text. More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user.$72.96
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide for Professional Excel Programmers$100.95 (Used)
VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel 5th EditionHelp your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Chris Albright's VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces students to the fundamentals of VBA for Excel. The second half puts knowledge into action as it illustrates how to automate a number of management science models using VBA. Students learn how to use applications to present a user-friendly interface for inputs and results. This new edition improves code readability, introduces PowerPivot and the Excel Data Model and demonstrates a new method to pass information between modules and user forms that avoids using global variables.$168.24
101 Ready-To-Use Excel Macros 1st EditionSave time and be more productive with this helpful guide to Excel macros!

While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use.

Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge
Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to solve the problem
Provides an explanation of how each macro works and where to use the macro

With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.
$249.95


Bookmark and Share

eXTReMe Tracker

Yandex.Metrika