Error in large file import macro
On Thu, 19 May 2005 20:31:03 GMT, "Scott Calkins via OfficeKB.com"
wrote:
that many people linked to here for importing
What does this mean?
data longer than the 65536 rows permited in excel. Wen I run it, it
loads
in the first line ok then errors out. It gives me a "Input past end of
file" error at Line Input #FileNum, ResultStr<.
This usually means that Line Input read past the end of the file
before encountering a chr$(13) or LF Chr$(10), the delimiter Line Input
uses to determine lines.
When you look at it in Notepad, is each item on it's own line? If
not, then the file doesn't have the delimiter it needs to use Line
Input.
|