If the files are in a form that Excel can import directly, look at the Excel
Open* functions and have Excel read the lines directly. Excel is an "out of
process" automation object, which requires that every call to it go though a
whole slew of security and process boundary change validation and support
code in Windows, which is why it's so slow.

Mike.

"Pat Lenahan" wrote in message
...
I've created a VB6 program to read files and post them to an excel
spreadsheet. But, when it posts to the spreadsheet its slow. About 1/2 a
second per line. Is this unusual or is there a better way or is this
normal?

Pat