vb: append data to text file

mmin8 · 05-19-2005, 02:05 AM

I'm working with access 2000 and I've wrote a macro in visual basic to write data on a text file (visualbasic ver.6).

I'm writeing the data in appending mode, but I'd like to write the data every time in new line, unfortunately the data are placed all on the same line...
How can I append the data on a new line?

Hereafter the code I wrote:
...
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim f, fs
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile("c:\temp\timerec.txt", ForAppending, -2)
f.write ("date: " & Date)
f.Close
...

Hope you can help me
Thanks
Marco

chloroformed · 06-07-2005, 08:00 AM

try using f.WriteLine instead of f.Write

mmin8 · 06-07-2005, 06:08 PM

I found it:
& vbcrlf = visual basic carriage return line feed
Regards
MM

05-19-2005, 02:05 AM	#1 (permalink)
mmin8 Registered User Join Date: Apr 2005 Posts: 9 OS: xp	vb: append data to text file I'm working with access 2000 and I've wrote a macro in visual basic to write data on a text file (visualbasic ver.6). I'm writeing the data in appending mode, but I'd like to write the data every time in new line, unfortunately the data are placed all on the same line... How can I append the data on a new line? Hereafter the code I wrote: ... Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim f, fs Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile("c:\temp\timerec.txt", ForAppending, -2) f.write ("date: " & Date) f.Close ... Hope you can help me Thanks Marco

06-07-2005, 06:08 PM	#3 (permalink)
mmin8 Registered User Join Date: Apr 2005 Posts: 9 OS: xp	vbcrlf = visual basic carriage return line feed I found it: & vbcrlf = visual basic carriage return line feed Regards MM Last edited by mmin8; 06-07-2005 at 06:10 PM.

06-07-2005, 08:00 AM	#2 (permalink)
chloroformed Registered User Join Date: Jun 2005 Posts: 1 OS: XP/2000	try using f.WriteLine instead of f.Write