I would just like to say a big thank you to everyone who has added comments
to this thread, I was having performance problems with Excel reading a 17meg
text file, I was taking about 5 mins to read the whole file.

With the comments and help added here, I have been able to get this down to
seconds.

Again, a big thank you to everyone.

--
Cheers...


"Mark HOlcomb" wrote:

,I have written an application in VBA that reads a very large binary file.
I am pleased that it works at all .. but it runs too slow to be of any
practical use. I read 4 bytes at a time, then convert. The file is a
mixture of integer, ascii and floating point data. And very large. I want
to read several of these files in succession.
Would the stream reader speed things up? Or, if I transformed it into VB,
would it go faster? Is there an inheriant speed problem with VBA because it
is wrapped up in EXCEL? I only use VBA because I am most familiar with that
user interface.

Any comments are greatly appreciated.

Mark