It depends on where your problem is.
If the file is too large to load into the stream with LoadFromFile
then there is no easy answer.
If the problem is simply that your Response buffer is too small, then it's fixable.
objStream.Read can take one argument: The number of bytes to read. So you can do this in chunks.
In place of
you could try doing:
CONST CHUNK = 100000 ' experiment to get best chunk size
byteCount = objStream.Size
Do While byteCount > CHUNK
byteCount = byteCount - CHUNK
This is untested code. I remember doing something like this almost 10 years ago, so I'm really dredging this out of vary old human memory. (Both the human and the memory are old.)