The Repetition Structure

Lecture 11

08/07/06

Dan Rao

The Repetition Structure

• Sequence programming structure

• The selection structure

• The repetition structure

The For…Next Statement

For Each…Next Statement

The With Statement

Using the Repetition Structure and the With Statement in Excel

• Open the monthlySales.xls workbook.

• Open the MthSales.mdb database.

Using Microsoft Query

• Microsoft Query is a separate program that comes with Microsoft Excel, and it is usedto bring data from a database into anExcel worksheet

• Microsoft Query can retrieve data from the following database sources: Microsoft SQL Server OLAP Services, Microsoft Access 2000, dBASE, Microsoft FoxPro, Microsoft Excel, Oracle, Paradox, SQL Server, and text file databases

The QueryTables Collection and QueryTable Objects

• Each QueryTable object represents a worksheet table built from data retrieved from an external data source

• You can use the QueryTable object’s CommandText property to select a different set of records to retrieve from the database and display in the worksheet

The Current Region Properties

• rangeObject.CurrentRegion

• It returns a range that contains the entire region in which the Range object resides.

The Resize Method