Can VB write a string to a text file? (1 Viewer)

[shacket]

I know about TransferText - i.e. creating a delimited text file with values from a table. What I want to do is have VBA create a string (I can do that) and write a text file that is the string.

In other words, VB creates the string:

"This is a great Access forum"

and writes a text file whose content is:

"This is a great Access forum"

Any thoughts?

 

[pcs]

something like:

Open "c:\yourPath\yourFile.txt" For Append As #1
Write #1, YourString
Close #1

(check help on append/output)

hth,
al