"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
Module: modSnippetQueryTable
Working with Excel Query Table Objects
Excel makes it easy to insert data from other applications using Query Tables. You can also access and create Query Table objects through code. This module contains example code to show you how to programmatically work with Query Table objects.
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modSnippetQueryTable module
|
|
QueryTableCreateFromText
|
Procedure
|
Creates a new query table object using the contents of a text file
|
|
QueryTableCreateJetADO
|
Procedure
|
Creates a new query table object using ADO to get data from a Access/Jet database
|
|
QueryTableCreateJetDAO
|
Procedure
|
Creates a new query object using DAO to get data from a Access/Jet database
|
|
QueryTableCreateSS_ADO
|
Procedure
|
Creates a new query table object using ADO to get data from a SQL Server database
|
|
QueryTablesDelete
|
Procedure
|
Shows how to delete all query table objects from the current worksheet
|
|
QueryTablesEnumerate
|
Procedure
|
Enumerates all query tables in the current worksheet
|
|
QueryTableSetRefresh
|
Procedure
|
Shows how to set the Refresh interval for a specified query table object.
|
|
QueryTablesRefresh
|
Procedure
|
Refreshes all query tables in the current worksheet
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
