View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan R. Dan R. is offline
external usenet poster
 
Posts: 220
Default Writing to a .txt File

Is this the proper way to write to a .txt file? Something must be out
of order b/c the status of the first x is printed next to the second x
on the out file, and the status of the second x is printed next to the
third x and so on.

Close
Open out For Output As #2
Close
Open in For Input As #1

While (EOF(1) < True)
Input #1, x
x = Mid(x, 1, 10)

Close #2
Open out For Append As #2
Print #2, x & "|" status

' Do Stuff

Wend

Thanks,
-- Dan