Programming Excel with VBA & .NET
(Sprache: Englisch)
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...
Leider schon ausverkauft
versandkostenfrei
Buch (Kartoniert)
53.00 €
Produktdetails
Produktinformationen zu „Programming Excel with VBA & .NET “
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.
Klappentext zu „Programming Excel with VBA & .NET “
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already. 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 isa 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-and those subjects correspond 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 awayin 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
... mehr
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 is.
... weniger
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.
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.
Inhaltsverzeichnis zu „Programming Excel with VBA & .NET “
PrefacePart I. Learning VBA1. Becoming an Excel ProgrammerWhy Program?
Record and Read Code
Change Recorded Code
Fix Misteakes
Start and Stop
View Results
Where's My Code?Macros and Security
Write Bug-Free Code
Navigate Samples and Help
What You've Learned2. Knowing the Basics
Parts of a Program
Classes and Modules
Procedures
Variables
Conditional Statements
Loops
Expressions
Exceptions
What You've Learned3. Tasks in Visual Basic
Types of Tasks
Interact with Users
Do Math
Work with Text
Get Dates and Times
Read and Write Files
Check Results
Find Truth
Compare Bits
Run Other Applications
Control the Compiler
Not Covered Here
What You've Learned4. Using Excel Objects
Objects and Their Members
Get Excel Objects
Get Objects from Collections
About Me and the Active Object
Find the Right Object
Common Members
Respond to Events in Excel
Autoren-Porträt von Jeff Webb, Steve Saunders
Steve Saunders is a Microsoft veteren who helped pioneer the design of hypertext help systems that paved the way for the design of today's Web sites. He was lead designer for the award-winning Microsoft Access and Basic help systems, and was a charter member of the Visual Basic product team. Later, Steve wrote documentation for Access programmers and became an Access programmer himself, creating applications for his group at Microsoft and for a growing list of clients outside the company.Businesses and non-profit organizations use Steve's affordable custom applications to track their critical information, including customers and orders, lodging reservations, real estate listings, donors and donations. Since 1996, the Methow Valley Sport Trails Association (MVSTA) has used his race management application, Racetracker, to produce accurate and timely results for its popular cross-country ski and running races.Before his years at Microsoft, Steve was a reporter and editor for newspapers in Utah, Maine, and Massachusetts, and a technical writer in the database group at Digital Equipment Corp. He holds a master's degree in journalism from Boston University, a graduate certificate in technical writing from Northeastern University, and a bachelor's degree in technical writing and creative writing from Carnegie-Mellon University.Currently a principal of Smiling Country, Steve enjoys combining his technical, design, and editorial expertise to help businesses succeed.Jeff Webb is a SharePoint consultant and trainer who has written about computers and technology for 20 years. Among his published O'Reilly titles are Essential SharePoint, SharePoint Office Pocket Guide, Programming Excel with VBA and .NET, and Excel 2003 Programming: A Developer's Notebook. Jeff was an original member of Microsoft's Visual Basic team.
Bibliographische Angaben
- Autoren: Jeff Webb , Steve Saunders
- 2006, XVI, 1090 Seiten, Maße: 18 x 23,6 cm, Kartoniert (TB), Englisch
- Herausgegeben: Simon St.Laurent, John Osborn
- Verlag: O'Reilly Media
- ISBN-10: 0596007663
- ISBN-13: 9780596007669
Sprache:
Englisch
Kommentar zu "Programming Excel with VBA & .NET"
0 Gebrauchte Artikel zu „Programming Excel with VBA & .NET“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Programming Excel with VBA & .NET".
Kommentar verfassen