Is there a way to turn security and or validation off. Excel cant read it
from a file because I do some complex code to get the information I need
accessing a clarion database.

Pat

"Michael D. Ober" <[email protected] wrote in message
...
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