Programming Excel with VBA And . NET : Solve Real-World Problems with Excel by Steve Saunders and Jeff Webb (2006, Perfect)

Great Book Prices Store (335037)
96.5% positive Feedback
Price:
US $45.02
Approximately£33.33
+ $19.99 postage
Estimated delivery Mon, 2 Jun - Thu, 12 Jun
Returns:
14 days return. Buyer pays for return postage. If you use an eBay delivery label, it will be deducted from your refund amount.
Condition:
New
Webb and Saunders explain how to program Excel using Visual Basic for Applications (VBA) and. NET, starting with two chapters for beginners. Techniques include specific tasks with VBA, using and creating objects, and writing code.

About this product

Product Identifiers

PublisherO'reilly Media, Incorporated
ISBN-100596007663
ISBN-139780596007669
eBay Product ID (ePID)51256817

Product Key Features

Number of Pages1114 Pages
Publication NameProgramming Excel with Vba and .net : Solve Real-World Problems with Excel
LanguageEnglish
Publication Year2006
SubjectProgramming Languages / Visual Basic, General, Desktop Applications / Spreadsheets, Programming Languages / Asp.Net, Operating Systems / Windows Desktop
TypeTextbook
Subject AreaComputers
AuthorSteve Saunders, Jeff Webb
FormatPerfect

Dimensions

Item Height2.4 in
Item Weight64.3 Oz
Item Length9.2 in
Item Width7 in

Additional Product Features

Intended AudienceScholarly & Professional
LCCN2006-283506
IllustratedYes
Table Of ContentPreface Part I: Learning VBA Chapter 1: Becoming an Excel Programmer Chapter 2: Knowing the Basics Chapter 3: Tasks in Visual Basic Chapter 4: Using Excel Objects Chapter 5: Creating Your Own Objects Chapter 6: Writing Code for Use by Others Part II: Excel Objects Chapter 7: Controlling Excel Chapter 8: Opening, Saving, and Sharing Workbooks Chapter 9: Working with Worksheets and Ranges Chapter 10: Linking and Embedding Chapter 11: Printing and Publishing Chapter 12: Loading and Manipulating Data Chapter 13: Analyzing Data with Pivot Tables Chapter 14: Sharing Data Using Lists Chapter 15: Working with XML Chapter 16: Charting Chapter 17: Formatting Charts Chapter 18: Drawing Graphics Chapter 19: Adding Menus and Toolbars Chapter 20: Building Dialog Boxes Chapter 21: Sending and Receiving Workbooks Part III: Extending Excel Chapter 22: Building Add-ins Chapter 23: Integrating DLLs and COM Chapter 24: Getting Data from the Web Chapter 25: Programming Excel with .NET Chapter 26: Exploring Security in Depth Part IV: Appendixes Appendix A: Reference Tables Appendix B: Version Compatibility Colophon
SynopsisWhy 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 ......, 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. Withboth 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., 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.
LC Classification NumberHF5548.4.M523W43

All listings for this product

Buy it now
Any condition
New
Pre-owned
No ratings or reviews yet
Be the first to write a review