ADO Stream object: Size Property

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions Material Management  |  Guestbook
 

ADO Stream object: Size Property

The Size property returns a long value that is the size in bytes of the data stored in the Stream object.

Note that this property requires that the Stream be open. If it is not open, an error will be generated. If the size is not known, the return value is -1. If the size exceeds the upper limit of a long value, a truncated size is returned.

Syntax

objStream.Size

Example


Set objStream = New ADODB.Stream
objStream.Open rsData, adModeShareExclusive
'..... some code

Dim lngStreamSize
lngStreamSize = objStream.Size