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
|