Access it using the worksheet.ListIbjects property
Dim mytable As ListObject
mytable.DataBodyRange - the cells containing the actual data (excluding header & insert row)
mytable.HeaderRowRange
mytable.ShowAutoFilter
mytable.ShowTables
mytables.TotalsRowRange



Usually the simplest way to extract data from a database is by means of the MS Query program.
This can be launched from (Data > Get External Data > New Database Query).
The settings implemented in MS Query can be controlled by the QueryTable object.
In Excel 2000 this object has a lot more properties.





Display the data form

Before you can display the Data Form you must select a cell in the database table first.

Range("B2").Select 
Application.ActiveSheet.ShowDataForm
ActiveSheet.ShowDataForm


There are several ways to connect to an external data source
Before you can connect to a database, you must add the appropriate reference to your project.





© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext