Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Programming Excel with VBA and .NET
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Programming Excel with VBA and .NET

Programming Excel with VBA and .NET

Jeff Webb, Steve Saunders

1114 pages, parution le 12/05/2006

Résumé

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

L'auteur - Jeff Webb

Jeff Webb est devenu formateur et consultant sur SharePoint après avoir été un des membres de l'équipe d'origine de Visual Basic chez Microsoft. Il écrit des livres sur l'informatique et les technologies depuis vingt ans. Il est l'auteur de nombreux titres chez O'Reilly dont Essential SharePoint, SharePoint Office Pocket Guide, Programming Excel with VBA and .NET ou encore Excel 2003 Programming: A developer's Notebook.

Sommaire

  • Learning VBA
    • Becoming an Excel programmer
    • Knowing the basics
    • Tasks in Visual Basic
    • Using Excel objects
    • Creating your own objects
    • Writing code for use by others
  • Excel Objects
    • Controlling Excel
    • Opening, saving, and sharing workbooks
    • Working with worksheets and ranges
    • Linking and embedding
    • Printing and publishing
    • Loading and manipulating data
    • Analyzing data with pivot tables
    • Sharing data using lists
    • Working with XML
    • Charting
    • Formatting charts
    • Drawing graphics
    • Adding menus and toolbars
    • Building dialog boxes
    • Sending and receiving workbooks
  • Extending Excel
    • Building add-ins
    • Integrating DLLs and COM
    • Getting data from the Web
    • Programming Excel with .NET
    • Exploring security in depth
Voir tout
Replier

Caractéristiques techniques

  PAPIER
Éditeur(s) O'Reilly
Auteur(s) Jeff Webb, Steve Saunders
Parution 12/05/2006
Nb. de pages 1114
Format 17,5 x 23,5
Couverture Broché
Poids 1405g
Intérieur Noir et Blanc
EAN13 9780596007669
ISBN13 978-0-596-00766-9

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription