Kategoria BISAC: Computers >> Languages - Visual BASIC

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

On the surface, it doesn't appear as if much in Excel 2003 has changed. There are a handful of new objects and the user interface is largely the same. But beyond a superficial glance, you'll see that there are fundamental shifts implied by the new features: Lists, XML, web services, .NET, and InfoPath build a framework for entirely new ways to exchange data with Excel. In fact, that's much of what Excel 2003 is all about--solving problems that deal with teamwork-- collecting and sharing data, programming across applications, and maintaining security.The latest in our Developer's Notebook...

Getting data across platforms and formats is a cornerstone of present-day applications development. ADO: ActiveX Data Objects is both an introduction and a complete reference to ADO (ActiveX Data Objects), Microsoft's universal data access solution. You'll learn how to easily access data in multiple formats--such as email messages, Access databases, Word documents, and SQL databases--even on different platforms, without spending extra time learning every last detail about each format.Author Jason Roff shows by example how to use ADO with your programming language of choice to save...

Many Microsoft Word users and VBA programmers don't realize the extensive opportunities that exist when Word's Object Model is accessed using Visual Basic for Applications (VBA), which replaced WordBasic in conjunction with the release of Word 97. By creating what is commonly called a "Word Macro" you can automate many features available in Word. Writing Word Macros (previously titled Learning Word Programming is the introduction to Word VBA that allows you to do these things and more, including:

• Create custom pop-up menus
• Automatically create tables from...

Calling all Visual Basic .NET programmers and web developers This highly anticipated book provides thorough instruction for using ADO.NET, supported with numerous relevant code examples and extensive technical information. So whether you're developing web applications using ASP.NET, Windows Forms applications, or XML Web Services, you'll become adept at maximizing .NET's data access technology.

Topics include: ADO.NET data architecture; data readers, adapters, and DataSets; safer development with XML Schemas; data relationships; and ADO.NETs built-in support and performance...

Are you ready for the future of data access in .NET?

At the Microsoft Professional Developers Conference (PDC) 2005, Microsoft previewed a new technology, Language-Integrated Query (LINQ). It captured a lot of attention because it addressed the fundamental issue of merging object-oriented applications with relational data. The LINQ project team demonstrated how to use LINQ to query a variety of data sources, such as a SQL Server database, an XML file, and an array, and how to manage the data using an object-oriented approach.

Fabio Ferracchiati has written a...

From seasoned developer and trainer Rob Macdonald comes Serious ADO: Universal Data Access with Visual Basic, which teaches experienced Visual Basic developers how to make the most of ADO, Microsoft's flagship product for database access. Serious ADO covers the full range of uses for ADO, from basic use of the ADO technology to specialized topics and advanced techniques that will benefit even the most experienced developers.

The first part of the book provides thorough coverage of ADO's components and what they can do. Along the way, Macdonald offers...