View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 3
Default 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.