Reglas del Foro
1. Antes de hacer tu pregunta intenta con el buscador de este foro (muchas preguntas ya fueron respondidas antes!) 2. Si haces una nueva pregunta, es muy recomendable que adjuntes el ejemplo Excel para poder comprenderla mejor! 3. Realiza tu pregunta de forma clara, explicando bien cada paso de lo que haces y tendrás más probabilidad de respuesta!
VBA Language References
In this section, find reference documentation designed to help you customize Microsoft Office and to extend and integrate it with other applications.
Visual Basic 5.0/6.0 Sample: Treeview.exe
Brief Description
This sample illustrates how to manipulate nodes with the TreeView control.It also illustrates how to save the node information to an Access database,and then restore them. Additionally, this sample implements the drag-and-drop feature for TreeView control nodes.
Data Tree VB Sample
Brief Description
The DataTree sample application demonstrates how to use the TreeView control and the ListView control to view the contents of a small database (Biblio.mdb). The ProgressBar control is also used to give the user a visual indication of how long a process is taking.
Getting Started: Microsoft Windows CE Toolkit for Visual Basic 6.0
Brief Description
This sample code is provided in conjunction with the MSDN Library article, "Getting Started: Microsoft Windows CE Toolkit for Visual Basic 6.0.
Visual Basic .NET Code Sample: Create a Database
Brief Description
This application shows you how to execute SQL statements from code using ADO .NET. It creates a database, a table, a stored procedure, and a view. SQL statements are then executed that populate the table with data from the Northwind database.
http://www.microsoft.com/downloads/deta ... laylang=en
Visual Basic .NET Code Sample: Encrypt and Decrypt Data
Brief Description
Symmetric encryption uses a single shared, secret key to encrypt and decrypt data. Anyone that has the key can decrypt the data, which makes protection of the key vital. Private-key encryption is much faster than public-key encryption which makes it ideal for use on large streams of data.
http://www.microsoft.com/downloads/deta ... laylang=en
Visual Basic .NET Code Sample: Creating a Windows Service
Brief Description
The code demonstrates how to build a Windows Service that includes methods that respond when the service is started, stopped, paused, continued, and when the service is stopped due to a system shut down.
http://www.microsoft.com/downloads/deta ... laylang=en
Visual Basic .NET Code Sample: Use Stored Procedures
Brief Description
This application demonstrates how to programmatically create and use stored procedures with ADO .NET and Microsoft SQL Server. The use of a query (a.k.a., stored procedure) in a Microsoft Access database is also demonstrated.
http://www.microsoft.com/downloads/deta ... laylang=en
ADO.NET and Visual Basic .NET
Brief Description
Microsoft .NET includes a new data access technology called ADO.NET. There are numerous reasons why we have a new data access technology, including intrinsic support for disconnected data, comprehensive XML support, and making the technology fit seamlessly into the overall .NET Framework.
http://www.microsoft.com/downloads/deta ... laylang=en
Visual Basic .NET Code Sample: Using Typed Datasets
Brief Description
This sample shows the difference between an untyped dataset and a typed dataset when doing inserts, updates, deletes, and queries. A typed dataset gives the programmer the ability to reference tables and fields using IntelliSense at design time.
http://www.microsoft.com/downloads/deta ... laylang=en
Visual Basic .NET Code Sample: Arrays
Brief Description
The application shows how to work with an array of value types, strings, and an array of reference types, a custom Customer object. The Customer object exposes public Id and Name fields.
http://www.microsoft.com/downloads/deta ... laylang=en
Office 2003 Editions: Excel VBA Language Reference
Brief Description
This download contains the Microsoft® Office Excel 2003 Visual Basic® for Applications (VBA) Language Reference as a compiled Help file.
http://www.microsoft.com/downloads/deta ... layLang=en