04 CopyBuf - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

CopyBuf method

Copies the buffer from another TableData object. Returns True if successful, otherwise False.

Applies to

TableData ArrData RsetData Xdata XShared

Parameters

Name Type Description
Td TableData object The TableData object from which the buffer is to be copied.

This can be used to transfer data from one TableData object to another. All the fields in the TableData object being copied must be present in the destination TableData object (though not necessarily in the same order).

Buffer procedures return or change values in a single row, reading or saving one row at a time. They are for use when rows are to be accessed randomly, and will be more efficient than processing each cell individually with Value, but if rows are to be read or written sequentially then the record level procedures (RecValue etc.) will be most efficient.