Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

VBA


1. 

Mastering VBA for Microsoft Office 2013

Mastering VBA for Microsoft Office 2013

By: 

Publisher: Sybex

Publication Date: 26-AUG-2013

Insert Date: 11-FEB-2014

Slots: 1.0

Table of Contents • Start Reading

A 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...

2. 

Richtig einsteigen: Excel VBA-Programmierung. Für Microsoft Excel 2007 bis 2013

Richtig einsteigen: Excel VBA-Programmierung. Für Microsoft Excel 2007 bis 2013

By: Bernd Held

Publisher: Microsoft Press Deutschland

Publication Date: 17-JUN-2013

Insert Date: 14-JUN-2013

Slots: 1.0

Table of Contents • Start Reading

In kurzen und leicht verständlichen Abschnitten führt Sie Bernd Held von der ersten Codezeile bis zu fortgeschrittener Excel VBA-Programmierung. Für Excel 2007-2013....

3. 

Excel® 2013 VBA and Macros, Video Enhanced Edition

Excel® 2013 VBA and Macros, Video Enhanced Edition

By: Bill Jelen; Tracy Syrstad

Publisher: Que

Publication Date: 04-FEB-2013

Insert Date: 08-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

SAVE 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...

4. 

Excel Programming with VBA Starter

Excel Programming with VBA Starter

By: Robert Martin;

Publisher: Packt Publishing

Publication Date: 18-OCT-2012

Insert Date: 25-OCT-2012

Slots: 1.0

Table of Contents • Start Reading

Get started with programming in Excel using Visual Basic for Applications (VBA) 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...

5. 

Excel® VBA: 24-Hour Trainer

Excel® VBA: 24-Hour Trainer

By: 

Publisher: Wrox

Publication Date: 03-MAY-2011

Insert Date: 12-MAY-2011

Slots: 1.0

Table of Contents • Start Reading

This unique book-and-video package of Excel® VBA: 24-Hour Trainer, helps even non-programmers extend Excel with VBA Virtually every manual task in Excel can be automated with VBA, which increases your productivity and saves enormous amounts of time. This unique book-and-video package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate many routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons and illustrations, while the accompanying DVD provides demos and screencasts to complement...

6. 

Numerical Methods with VBA Programming

Numerical Methods with VBA Programming

By: James Hiestand

Publisher: Jones & Bartlett Learning

Publication Date: 25-OCT-2010

Insert Date: 16-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

Numerical Methods with VBA Programming provides a unique and unified treatment of numerical methods and VBA computer programming, topics that naturally support one another within the study of engineering and science. This engaging text incorporates real-world scenarios to motivate technical material, helping students understand and retain difficult and key concepts. Such examples include comparing a two-point boundary value problem to determining when you should leave for the airport to catch a scheduled flight. Numerical examples are accompanied by closed-form solutions to demonstrate their...

7. 

VBA für Dummies®

VBA für Dummies®

By: John Paul Mueller

Publisher: für Dummies

Publication Date: 02-APR-2008

Insert Date: 04-JUN-2009

Slots: 1.0

Table of Contents • Start Reading

Mit VBA (Visual Basic für Applikationen) können Sie Applikationen, zum Beispiel die Microsoft-Office-Komponenten Word, Excel und Access, auf Ihre Bedürfnisse zuschneiden und somit Programmabläufe steuern. In "VBA für Dummies" zeigt Ihnen John Paul Mueller, wie Sie eigene Benutzeroberflächen für die Microsoft-Office-2007-Applikationen erstellen, strukturierte VBA-Programme schreiben und tägliche Arbeiten automatisieren können. Er erklärt, wie Sie Formulare gestalten, Fehler in der VBA-Programmierung suchen und beheben und er führt Sie in die objektorientierte Programmierung ein. Außerdem...

8. 

Business Solutions VBA for the 2007 Microsoft® Office System

Business Solutions VBA for the 2007 Microsoft® Office System

By: 

Publisher: Que

Publication Date: 30-MAR-2007

Insert Date: 12-JAN-2007

Slots: 1.0

Table of Contents • Start Reading

“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able to reuse right away in your VBA projects.” —Guy Barrette, Microsoft MVP & Regional Director, .NET Expertise Develop your VBA expertise instantly with proven techniques VBA for the 2007 Microsoft® Office System shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or...

9. 

Microsoft® Excel VBA Programming for the Absolute Beginner, Second Edition

Microsoft® Excel VBA Programming for the Absolute Beginner, Second Edition

By: Duane Birnbaum

Publisher: Course Technology PTR

Publication Date: 01-JAN-2005

Insert Date: 19-OCT-2005

Slots: 1.0

Table of Contents • Start Reading

Coverage includes— Duane Birnbaum began programming in graduate school, where he wrote custom software for interfacing the electronic equipment required for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry in 1991, he has worked as a post-doctoral and research scientist in academia and industry while continuing to teach on a part-time basis. He has been teaching courses in introductory programming, database design, and data analysis in the Computer Science department at Indiana University/Purdue University at...

10. 

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA®

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA®

By: Stephen Bullen; Rob Bovey; John Green

Publisher: Addison-Wesley Professional

Publication Date: 01-FEB-2005

Insert Date: 22-FEB-2005

Slots: 1.0

Table of Contents • Start Reading

Finally, 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,...

11. 

VBA and Macros for Microsoft Excel

VBA and Macros for Microsoft Excel

By: 

Publisher: Que

Publication Date: 10-MAY-2004

Insert Date: 01-OCT-2004

Slots: 1.0

Table of Contents • Start Reading

Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site,...

12. 

Absolute Beginner's Guide to VBA

Absolute Beginner's Guide to VBA

By: 

Publisher: Que

Publication Date: 09-MAR-2004

Insert Date: 18-MAY-2004

Slots: 1.0

Table of Contents • Start Reading

Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic and it comes with your Office license. After reading this book, the reader will be proficient in the VBA language and will have extensive knowledge of the Office 2003 Object Model. This book will cover all features of the VBA editor and show how to program some of the more useful new features in the Office 2003 applications. This book assumes no prior programming experience, so even programming...

13. 

Office® XP Development with VBA

Office® XP Development with VBA

By: 

Publisher: Prentice Hall

Publication Date: 06-SEP-2001

Insert Date: 18-JUL-2003

Slots: 1.0

Table of Contents • Start Reading

Create custom business solutions with Microsoft Office XP and Office 2000! Extend Word, Excel, Outlook, and other Office applications. Learn all aspects of Office development, including security and distribution. Leverage Office's powerful collaboration, intranet, and Web capabilities For novice developers and Office power users! Discover the power of Office programming Applies to both Office XP and Office 2000 Master the Visual Basic for Applications (VBA) language and development environment Understand the powerful components in the Office...