VBA Books



Bookstore > Books > VBA

Going GAS

Going GAS

Whether you're moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.Office still supports VBA, but it's not likely to do so for much longer. If you're a VBA or .NET developer, you'l...
How to Implement Market Models Using VBA

How to Implement Market Models Using VBA

How to Implement Market Models Using VBA makes solving complex valuation issues accessible to any financial professional with a taste for mathematics. With a focus on the clarity of code, this practical introductory guide includes chapters on VBA fundamentals and essential mathematical techniques, helping readers master the numerical meth...
Excel VBA 24-Hour Trainer, 2nd Edition

Excel VBA 24-Hour Trainer, 2nd Edition

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-p...
Excel VBA Programming For Dummies, 3rd Edition

Excel VBA Programming For Dummies, 3rd Edition

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, writ...
Excel 2013 All-in-One For Dummies

Excel 2013 All-in-One For Dummies

As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The...
C# Database Basics

C# Database Basics

Working with data and databases in C# certainly can be daunting if you're coming from VB6, VBA, or Access. With this hands-on guide, you'll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C# - basic skills you need if you intend to program with this language.No previous knowledge o...
Excel Programming with VBA Starter

Excel Programming with VBA Starter

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....
Implementing Models of Financial Derivatives

Implementing Models of Financial Derivatives

Implementing Models of Financial Derivatives is a comprehensive treatment of advanced implementation techniques in VBA for models of financial derivatives. Aimed at readers who are already familiar with the basics of VBA it emphasizes a fully object oriented approach to valuation applications, chiefly in the context of Monte Carlo simulat...
Excel VBA 24-Hour Trainer

Excel VBA 24-Hour Trainer

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...
Microsoft Access 2010 VBA Programming Inside Out

Microsoft Access 2010 VBA Programming Inside Out

You're beyond the basics, so dive right in and customize, automate, and extend Access - using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power o...
Excel 2010 Made Simple

Excel 2010 Made Simple

Get the most out of Excel 2010 with Excel 2010 Made Simple - learn the key features, understand what's new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and u...
Pro Access 2010 Development

Pro Access 2010 Development

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (...
Excel VBA Programming For Dummies, 2nd Edition

Excel VBA Programming For Dummies, 2nd Edition

Take your Excel skills to the next level with VBA programmingNow that you've mastered Excel basics, it's time to move to the next level-creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and...
Excel 2010 Formulas

Excel 2010 Formulas

You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks,...
Pro Excel 2007 VBA

Pro Excel 2007 VBA

Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including coverage of new features in Excel 2007. Covering object - oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code...
Access 2007 VBA Bible

Access 2007 VBA Bible

Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft Office applications - and that's just for starters. In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you'll learn to write Visual Basic code that automates Access database tasks, creates standalone scripts, e...
Access Data Analysis Cookbook

Access Data Analysis Cookbook

This book offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financi...
AutoCAD 2007 and AutoCAD LT 2007 Bible

AutoCAD 2007 and AutoCAD LT 2007 Bible

Popular among both novice and experienced AutoCAD users, this comprehensive book begins with an overview of the basics of AutoCAD, such as creating drawings, using commands, and specifying coordinates. Coverage becomes more in-depth as each chapter builds off the previous one, with discussions of 2D and 3D drawing techniques, using layers...
Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

You're a sophisticated user of Excel - a real pro with spreadsheet - so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, ...
Writing Excel Macros with VBA, 2nd Edition

Writing Excel Macros with VBA, 2nd Edition

To achieve the maximum control and flexibility from Microsoft Excel often requires careful custom programming using the VBA (Visual Basic for Applications) language. Writing Excel Macros with VBA, 2nd Edition offers a solid introduction to writing VBA macros and programs, and will show you how to get more power at the programming level: f...

Pages: 1, 2 | Next→

Subscribe to Newsletter

Be the first to know about new IT books, upcoming releases, exclusive offers and more.