(Excel) Copy a File using a Stream

Nobody would actually copy a file using this method. The purpose of this example is to demonstrate the SourceFile and SinkFile properties, and the RunStream method.

When RunStream is called, the source is read until the end-of-stream condition occurs. All incoming data is copied to the stream's sink. In this example the sink is also a file. A typical application might employ a file as the source or sink, but not both. Usually one side of the stream will be the application itself reading or writing, or perhaps another stream object.

Download Excel Class Modules Chilkat Excel Class Modules

Dim stream As Chilkat.Stream
Set stream = Chilkat.NewStream

stream.SourceFile = "qa_data/hamlet.xml"
stream.SinkFile = "qa_output/hamlet_copy.xml"


success = stream.RunStream()
If (success <> True) Then
    Debug.Print stream.LastErrorText
    Exit Sub
End If

Debug.Print "File copied."