Experience learning made easy, and quickly teach yourself Microsoft Office Excel 2007 Visual Basic for Applications (VBA)–one step at a time! Work at your own pace through the easy numbered steps and practice files on CD, and master the fundamentals for using VBA to create custom software solutions and automating tasks in Excel 2007–no developer experience required! You'll learn how to automate spreadsheets, write your own functions and procedures, and customize menus and toolbars. You'll discover Excel Objects, including workbooks, range objects, graphics, and PivotTables®. Plus, you'll learn how to chart data from databases and other information sources. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction–building and practicing the skills you need, just when you need them! Includes a companion CD with hands-on practice files.

The goal of this book is to provide programmers, power users, and system administrators who have a previous programming background with a project-oriented approach to learning the VBScript (Visual Basic Scripting) language. VBScript is a member of the Visual Basic family of programming languages that includes both Visual Basic and VBA (Visual Basic for Applications).

VBScript is a scripting language that acts as a tool for rapid application development in a host of different operating environments. VBScript provides the ability to automate tasks on Windows operating systems using the WSH (Windows Script Host). The WSH provides VBScripts with access to Windows resources, such as the Windows file system, the desktop, the registry, and network resources. In addition, when combined with HTML and executed within Internet Explorer, VBScript allows the user to create interactive client-side Web content.

With this completely up-to-date tutorial and reference, you'll quickly learn how to develop Visual Basic (VB) programs that leverage the latest features of Vista and .NET 3.0. The tutorial section walks you through VB.NET from scratch, providing you with in-depth descriptions of the development environment, basic program syntax, and standard controls. You'll also explore the fundamental concepts in object-oriented programming with VB.

In the comprehensive reference section, you'll find out how to take advantage of specific VB features. Expert Rod Stephens shows you how to draw images, use GDI+ routines, and generate printed output. You'll also discover how to build an application that interacts with its environment, save and load data in external sources, and use standard dialog controls. This approach makes it easier than ever to learn this powerful language and create your own dynamic programs.

The topic combination of VB .NET and ADO.NET is unbeatable. VB .NET is the most popular language in which to code. And, every developer needs to understand ADO.NET to allow data to be accessed from a Web site. In this book Developers will be shown numerouse code examples that will illustr4ate how to program database driven applications within the .NET Framework. The book is aimed at both established and new VB Developers. Important topics covered include: Visual Studio development environment, ASP.NET applications, Windows Forms application, using VB .NET with ADO.NET, complex queries, security, COM interop., and application deployment.

This book is for the serious developer, whether corporate or independent, who wants to create database applications using Visual Basic .NET. If you are looking for a primer on .NET or even a beginner book for Visual Basic .NET, then you would be wise to pick up another book to give you the basics on those topics. This book focuses on the topic I love best: database development.

When Microsoft made Visual Basic into an object-oriented programming language, millions of VB developers resisted the change to the .NET platform. Now, after integrating feedback from their customers and creating Visual Basic 2005, Microsoft finally has the right carrot. Visual Basic 2005 offers the power of the .NET platform, yet restores the speed and convenience of Visual Basic. Accordingly, we've revised the classic in a Nutshell guide to the Visual Basic language to cover the Visual Basic 2005 version and all of its new features.

Unlike other books on the subject, Visual Basic 2005 in a Nutshell, 3rd Edition doesn't assume you're a novice. It's a detailed, professional reference to the Visual Basic language-a reference that you can use to jog your memory about a particular language element or parameter. It'll also come in handy when you want to make sure that there isn't some "gotcha" you've overlooked with a particular language feature.

Welcome to the new version of Visual Basic for 2005. As its name implies, Visual Basic is a visual way to create new programs for the Micro$oft Windows family of operating systems.
And though it is basic in many ways, the Visual Basic language is also very powerful. You can create new class libraries and XML Web services, as well as programs that you can use on your PC or your Web browser, or even your phone or PDA. Anything that can be done in Windows can be done in Visual Basic.

Programming in Visual Basic is easier than you might think, thanks to the visual tools supplied by Visual Studio. You don?t have to type line after line of code to create a working program ? Visual Studio automatically generates some code for you when you drag and drop components with the visual tools. Of course, being able to read and write code is important too, and this book provides plenty of code samples so you can understand the inner workings of your programs.

This book also shows you some best practices to keep in mind as you get further along in your programming. Your first programs may be very simple, but when you start getting into more complicated applications, you really need to plan out your program before you start writing the code.

The goal of this book is to make you immediately productive, creating Windows and Web applications using Visual Basic and its associated tools.

By creating applications, you will learn Visual Basic as it has evolved for .NET. You'll see how to use the tools effectively, and you'll learn the details of building robust object-oriented applications.

The focus of this book is on building Windows applications and building Web applications (including Web Services). In a sense, this is really two books in one. The first book could have been called Building Windows Applications with Visual Basic and Visual Studio 2005, and the second Building Web Applications And Web Services with Visual Basic and Visual Studio 2005. By putting them in a single volume, we can combine all the supplemental and background material, and give you more bang for your buck.

This book is intended for experienced VB programmers who are upgrading from VB6 or VS 2002/2003 to VB 2005. Basic familiarity with the VS 2005 integrated development environment (IDE) is assumed. However, no prior VB6, VBA, or VBScript database programming experience is necessary, except for Chapter 1, iMigrating from ADO to ADO.NET.î Some experience with writing Micro$oft Transact-SQL (T-SQL) statements and authoring simple stored procedures is expected. Familiarity with XML1.0 and XMLschemas will aid your understanding of DataSets and SQLServer 2005's new xml datatype. Some experience with writing XPath 1.0 expressions will be helpful to get the most benefit from Chapter 12, iExploring the xml Datatype.î

One-on-One Expert Visual Basic 2005 Database Programming concentrates on programming the .NET Framework 2.0's System.Data namespace, which implements ADO.NET 2.0 and related namespaces, such as System.Transactions and System.Xml. The book isn't a new user's guide to the .NET Framework, VS 2005, VBX, or VB 2005; it's devoted entirely to data-related topics.

This book is divided into four parts of three chapters each. Most chapters build on the knowledge you've gained from preceding chapters. Thus, it's recommended that you work your way through the chapters sequentially. Following is a brief description of the parts and their chapters' contents.

In this book, we cover Visual Basic virtually from start to finish. We begin by looking at the .NET Framework and end by looking at the best practices for deploying .NET applications. In between, we look at everything from database access to integration with other technologies such as XML, along with investigating the new features in detail. You will see that Visual Basic 2005 has emerged as a powerful yet easy-to-use language that will allow you to target the Internet just as easily as the desktop.

This book is written to help experienced developers learn about Visual Basic 2005. From those who are just starting the transition from earlier versions to those who have used Visual Basic for a while and need to gain a deeper understanding, this book provides a discussion on the most common programming tasks and concepts you need.

Although, it is possible to create Visual Basic applications using the command-line tools contained in the.NET Framework SDK, you will need Visual Studio 2005 (Professional or higher), which includes the .NET Framework SDK, to get the most out of this book. You may use Visual Studio .NET 2002 or Visual Studio 2003 instead, but there may be cases where much of the lessons will just not work because functionalities and capabilities will not be available in these older versions.

Visual Basic 2005 Programmer's Reference Visual Basic 2005 adds new features to Visual Basic (VB) that make it a more powerful programming language than ever before. This combined tutorial and reference describes VB 2005 from scratch, while also offering in-depth content for more advanced developers. Whether you're looking to learn the latest features of VB 2005 or you want a refresher of easily forgotten details, this book is an ideal resource. Well-known VB expert Rod Stephens features the basics of Visual Basic 2005 programming in the first half of the book.

The second half serves as a reference that allows you to quickly locate information for specific language features. It's a comprehensive look at programming using the increased set of language options offered with the VB 2005 release, confirming that there has never been a better time to learn Visual Basic than now. What you will learn from this book: The fundamental concepts of object-oriented programming with Visual Basic, including classes and structures, inheritance and interfaces, and generics How an application can interact with its environment, save and load data in external sources, and use standard dialog controls The syntax for declaring subroutines, functions, generics, classes, and other important language concepts