View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leho Leho is offline
external usenet poster
 
Posts: 1
Default Using text files

I have a problems working with files in excel vba.
Can somebody please tell me a little about this problem.

I just want to read from txt fail char-by-char and make a string from
each line and then work with these strings. Is it possible?

Here I'm just trying to do something with files. But no luck :(

Private Sub with_files()
Open "C:\WINDOWS\Desktop\Projekt\minu" For Random Access Read Write
lock Write As #3 Len = Len(" ")
Put #3, , "M"
' Here it says that bad record lenght and error 59.
Get #3, , loetud
MsgBox loetud
Close #3
End Sub