Probably best to just use standard VBA
commands:

OPEN
WRITE/PRINT
CLOSE

see VBA help.

Sub WriteToFile()
Open "c:\myfile.txt" For Append Access Write As #1
Print #1, "some text", "some more"
Write #1, "some text", "some more" 'quoted (CSV files)
Close #1
End Sub



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Hennie wrote :

I am using an excel-form to write to an excel-list, but want to write
to a text file. I haven't got MSAccess on my computer. I am using
Excel 2000. Please tell me I can and how.
Thanks
HennieJ