View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Randy[_10_] Randy[_10_] is offline
external usenet poster
 
Posts: 16
Default Append Records to a Text File

Thanks. I think that your suggestion is on the right track. However,
I've never worked with this type of code, so I have some questions, if
you don't mind.

1. Can you explain what the line ff = FreeFile() does? I searched the
group but can't figure this out.
2. The line "Open "C:\textfile.txt" For Output As ff ". Does this
file have to already exist or will this code create a new file if it
doesn't?
3. By the time that I would get to this subroutine, my records will
have already been concatenated into a single cell on each row. How
would the nested for-next loop change in this scenario?
4. Finally, will the line "Close ff" save the file or do I need to do
that in a separate command?

Thanks very much. Sorry for the ignorance.
Randy