RefreshStyle Property [Excel 2003 VBA Language Reference]
|XlCellInsertionMode can be one of these XlCellInsertionMode constants.|
|xlInsertDeleteCells. Partial rows are inserted or deleted to match the exact number of rows required for the new recordset.|
|xlOverwriteCells. No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.|
|xlInsertEntireRows. Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet.|
expression Required. An expression that returns one of the objects in the Applies To list.
This example adds a query table to Sheet1. The RefreshStyle property adds rows to the worksheet as needed, to hold the data results.
Dim qt As QueryTable Set qt = Sheets("sheet1").QueryTables _ .Add(Connection:="Finder;c:\myfile.dqy", _ Destination:=Range("sheet1!a1")) With qt .RefreshStyle = xlInsertEntireRows .Refresh End With