Results 1 to 2 of 2

Thread: Opening a sequential file, not comma delimited

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2000
    Posts
    1

    Post

    How do I read/open a text file which I want to delimit on a line by line basis even if it has commas in it?

    Thanks

    ------------------
    Sean

  2. #2
    New Member
    Join Date
    Feb 2000
    Posts
    12

    Post

    Use Line Input as this example from help shows:
    Code:
    Dim TextLine
    Open "TESTFILE" For Input As #1   ' Open file.
    Do While Not EOF(1)   ' Loop until end of file.
       Line Input #1, TextLine   ' Read line into variable.
       Debug.Print TextLine   ' Print to the Immediate window.
    Loop
    Close #1   ' Close file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width