Pass variables to a .txt file 2

[Cloonalt]

How can I pass data to a .txt file. For example, I want a file named (fieldname).txt.

I want to write data to it:

Name: data
Address: data

Hope that makes sense. Any help is appreciated.

 

[Remou]

You can use the Open Statement or the FileSytemObject (TextStream).

 

[Cloonalt]

Can you point me to an example of that code?

Thanks.

 

[abaldwin]

Something to start with
dim stFilename as string
dim stName as string
dim stAddress as string

stfilename = "C:\mytext.txt"


Open stfilename for output as #1


Place code here to fill the variables from wherever you get them (db or controls or whatever)

print #1 "Name: " & stname
Print #1 "Address: " & staddress

close recordsets

Close #1



Standard open file and write to it. Many examples on web.

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[Remou]

Open Statement:

http://msdn.microsoft.com/archive/d...e/en-us/office97/html/output/F1/D6/S5B27D.asp

FileSystemObject:

http://msdn.microsoft.com/library/d...html/a3f17c7a-69a2-47d8-8b40-6a74646f4e1d.asp