Free Trial

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

Help

VBA


1. 

Richtig einsteigen: Access 2013 VBA-Programmierung

Richtig einsteigen: Access 2013 VBA-Programmierung

By: Lorenz Hölscher

Publisher: Microsoft Press Deutschland

Publication Date: 02-MAY-2013

Insert Date: 03-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Eine Einführung in VBA und die Möglichkeiten, Access-Datenbanken mit dieser Technologie zu entwerfen....

2. 

Excel® 2013 VBA and Macros

Excel® 2013 VBA and Macros

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

3. 

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (97 à 2010)

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (97 à 2010)

By: Mikaël Bidault

Publisher: Pearson France

Publication Date: 08-JUN-2012

Insert Date: 02-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Vous souhaitez automatiser vos manipulations sous Excel pour éviter d'avoir à refaire toujours les mêmes tâches ? De la simple macro enregistrée à la conception de programmes plus élaborés, cet ouvrage vous explique comment améliorer votre productivité ! Prenant en compte l'évolution d’Office, il vous aidera à développer des macros compatibles avec toutes les versions d’Excel. Vous découvrirez en détail les multiples outils de Visual Basic Editor et apprendrez à déboguer vos programmes et à gérer les erreurs. Vous saurez personnaliser l’environnement d’Excel à l’aide de programmes...

4. 

Microsoft® Access® 2010 VBA Programming Inside Out

Microsoft® Access® 2010 VBA Programming Inside Out

By: 

Publisher: Microsoft Press

Publication Date: 22-JUL-2011

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Get expert advice and learn how to build sophisticated and elegant business solutions with Access—using Microsoft® Visual Basic® for Applications (VBA). This book packs hundreds of timesaving solutions, troubleshooting tips, and workarounds, all in concise, fast-answer format....

5. 

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (de 1997 à 2010)

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (de 1997 à 2010)

By: Mikaël Bidault

Publisher: Pearson France

Publication Date: 02-JUL-2010

Insert Date: 04-DEC-2012

Slots: 1.0

Table of Contents • Start Reading

Vous souhaitez automatiser vos manipulations sous Excel pour éviter d'avoir à refaire toujours les mêmes tâches ? De la simple macro enregistrée à la conception de programmes plus élaborés, cet ouvrage vous explique comment améliorer votre productivité ! Prenant en compte l'évolution d'Office, il vous aidera à développer des macros compatibles avec toutes les versions d'Excel (de 1997 à 2010). Vous découvrirez en détail les multiples outils de Visual Basic Editor et apprendrez à déboguer vos programmes et à gérer les erreurs. Vous saurez personnaliser l’environnement d’Excel à l’aide de...

6. 

Excel Programming with VBA Starter

ShortCut

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

7. 

Excel 2003 VBA Programmer's Reference

Excel 2003 VBA Programmer's Reference

By: 

Publisher: Wrox

Publication Date: 09-JUL-2004

Insert Date: 01-AUG-2012

Slots: 1.0

Table of Contents • Start Reading

What is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book cover? In...

8. 

Excel® 2010 Power Programming with VBA

Excel® 2010 Power Programming with VBA

By: 

Publisher: John Wiley & Sons

Publication Date: 01-APR-2010

Insert Date: 13-APR-2012

Slots: 1.0

Table of Contents • Start Reading

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

9. 

Richtig einsteigen: Excel 2010 VBA-Programmierung

Richtig einsteigen: Excel 2010 VBA-Programmierung

By: Monika Can-Weber

Publisher: Microsoft Press Deutschland

Publication Date: 16-JUN-2010

Insert Date: 14-MAR-2012

Slots: 1.0

Table of Contents • Start Reading

Der einfache Einstieg in die Excel-Programmierung: In kurzen und leicht verständlichen Abschnitten führt Sie Monika Can-Weber von der ersten selbst geschriebenen Codezeile bis zur sicheren Beherrschung fortgeschrittener VBA-Programmierung. Sie lernen, wie Sie lästige Routineaufgaben automatisieren und Excel Ihren Bedürfnissen anpassen können. Nebenbei werden Ihnen die Grundlagen der VBA-Programmierung vermittelt, die auch auf andere Office-Programme übertragbar sind. Das Buch folgt einem didaktischen Konzept, das Ihnen mit vielen Übungen, praxisnahen Tipps und zusätzlichen Informationen auf...

10. 

Microsoft Excel 2010-Programmierung - Das Handbuch

Microsoft Excel 2010-Programmierung - Das Handbuch

By: Monika Can-Weber; Tom Wendel

Publisher: Microsoft Press Deutschland

Publication Date: 13-OCT-2010

Insert Date: 03-MAR-2012

Slots: 1.0

Table of Contents • Start Reading

Das umfassende Lehr- und Nachschlagewerk zur Excel 2010-Programmierung. Die beiden Excel-VBA-Experten Monika Can-Weber und Tom Wendel haben ihren Erfahrungsschatz in diesem Handbuch gebündelt und bieten Ihnen eine schier unerschöpfliche Quelle an Beispielen, wie Sie mit VBA Excel automatisieren, anpassen und erweitern. Von den grundlegenden Programmiertechniken und dem Verständnis des Objektmodells bis hin zur API- und Klassenprogrammierung erlernen Sie praxisnah die VBA-Programmierung in Excel. Darüber hinaus widmen sich die Autoren dem Umgang mit zukunftweisenden Technologien wie XML und...

11. 

Anwendungen mit Excel entwickeln : Professionelle Excel-VBA-Programmierung für die Versionen 2000 bis 2010

Anwendungen mit Excel entwickeln : Professionelle Excel-VBA-Programmierung für die Versionen 2000 bis 2010

By: Bernd Held

Publisher: Markt+Technik Verlag

Publication Date: 15-DEC-2010

Insert Date: 02-MAR-2012

Slots: 1.0

Table of Contents • Start Reading

Dieses Buch richtet sich an Anwender und Programmierer von Microsoft Excel (Versionen 2000 bis 2010), die Visual Basic für Applikationen (VBA) einsetzen wollen, um Automatisierungs-Makros, Tools & Add-ins und andere Helferlein für die tägliche Arbeit zu programmieren. Sie können die im Buch vorgestellten Tools und Programmierbeispiele Schritt für Schritt nachvollziehen, einsetzen und bei Bedarf anpassen. Der Autor war 8 Jahre lang MVP (Most Valuable Professional) für Excel ist ebenso in der Auftragsprogrammierung tätig und bietet regelmäßig VBA-Seminare auf seiner Homepage unter...

12. 

Excel-VBA: Mit über 1000 Makros für Excel 2000 bis 2010

Excel-VBA: Mit über 1000 Makros für Excel 2000 bis 2010

By: Bernd Held

Publisher: Markt+Technik Verlag

Publication Date: 15-SEP-2010

Insert Date: 28-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

Es ist die fünfte Ausgabe des überaus erfolgreichen Programmiertitels von Bernd Held, die kurz nach Erscheinen der Version 2010 von Microsoft Excel herauskommt. Programmierer können unter der neuen Office/Excel-Version, die noch stärker als bisher unter dem Zeichen des Internet-Einsatzes steht, die zahllos verbreiteten VBA-Programme und Schnittstellen aktualisieren sowie mit erweiterter Funktionalität neue entwickeln. Das Buch enthält noch ausführlicher als die bisherigen Ausgaben rund 1.000 Makros. Auf der mitgelieferten CD-ROM kann der Anwender über eine vollautomatische Suchen-Funktion...

13. 

Excel-VBA: Aktuell zu Excel 2010

Excel-VBA in 14 Tagen: Aktuell zu Excel 2010

By: Bernd Held

Publisher: Markt+Technik Verlag

Publication Date: 29-JUL-2010

Insert Date: 25-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

Daten anders visualisieren als mit den gängigen Diagrammen, Excel benutzerdefiniert einstellen, Datenbestände professionell und zeitsparend analysieren – nach 14 Tagen ist der Leser in der Lage, Excel mit VBA zu programmieren.Excel-Anwender ohne Programmierkenntnisse können ohne weiteres einsteigen. Da Excel häufig im Rahmen von Office eingesetzt wird, gehört ein Blick zu den anderen Office-Anwendungen wie z.B. zu Word mit dazu.Sie lernen ebenfalls, bereits bestehende VBA-Projekte zu pflegen, neue zu testen, Fehler zu finden und zu beseitigen....

14. 

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

15. 

Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

By: 

Publisher: Wrox

Publication Date: 26-MAR-2007

Insert Date: 24-MAR-2011

Slots: 1.0

Table of Contents • Start Reading

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats. ...

16. 

Access 2003 VBA Programmer's Reference

Access 2003 VBA Programmer's Reference

By: 

Publisher: Wrox

Publication Date: 09-APR-2004

Insert Date: 10-MAR-2011

Slots: 1.0

Table of Contents • Start Reading

Covers all features of VBA programming for Access database applications Begins with an overview of VBA and highlights what's new in Microsoft Access 2003, the most popular database system in the world Real-world code examples demonstrate each programming topic, including using the Access Object Model, VBA execution and error handling, creating database objects with VBA, writing secure VBA code, and much more Shows how Access 2003 provides enhanced XML support, making it easier for programmers to publish data to the Web and exchange it with other organizations ...

17. 

Beginning Access 2003 VBA

Beginning Access 2003 VBA

By: 

Publisher: Wrox

Publication Date: 24-SEP-2004

Insert Date: 03-MAR-2011

Slots: 1.0

Table of Contents • Start Reading

What is this book about? Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA. Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way. Not only do readers learn to build "stand-alone" desktop applications, but readers also learn how to integrate Access applications with Web Services, and...

18. 

Computing with Excel and VBA

Computing with Excel and VBA

By: S. I. Krishan

Publisher: Jones & Bartlett Learning

Publication Date: 25-OCT-2010

Insert Date: 28-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

Ideal for use in non-majors, introductory-level CS or CIS courses, Computing with Excel and VBA provides students with a clear emphasis on problem solving using the popular tools Excel and VBA. Numerous examples are presented throughout the text to illustrate key concepts, and several additional examples and exercises are provided as learning tools at the end of each chapter. All examples were developed to relate to practical situations that students will likely encounter in their work or studies. By using Excel to demonstrate how computers can be used to solve problems, students will gain a...

19. 

Excel 2007 VBA Programming with XML and ASP

Excel 2007 VBA Programming with XML and ASP

By: Julitta Korol

Publisher: Jones & Bartlett Learning

Publication Date: 23-JUN-2009

Insert Date: 28-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

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

20. 

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