Insert lines in notepad

[davides]

Hi there !
I want to insert some lines in a txt file(notepad) using vba code. Somethink like:

line1 bla bla bla
line2 bla bla bla
line3 bla bla bla
line4 bla bla bla
....

and I don`t know the code for inserting a text in a new line ! ...

Anyone can help me, please !
Thanks!

 

[namliam]

vbNewLine is the variable for putting in a new line assuming your NOT using notepad but rather using a 'proper' Open, Print/Write, close or a File object.

 

[davides]

@namliam ... in Access Help I don`t see any vbNewLine ... I`m using access 2003 ! I have to use that Notepad ... I can`t put in a report or another object!

 

[Galaxiom]

One does not write into a text file with Access via Notepad.

One common technique is to write to the text file via the TextStreamObject.

 

[namliam]

Try this see if you can figure it out from there:

Sub testNotepad()
Open "C:\TestFile.txt" For Output As #1
Print #1, "Write some text"
Print #1, "Into a notepad"
Print #1, "text file"
Print #1, "make into " & vbNewLine & " make into two lines"
Close #1

End Sub

 

[davides]

GalaxiomAtHome, what do you mean with TextStreamObject ?

 

[jdraw]

GalaxiomAtHome, what do you mean with TextStreamObject ?

I think he was thinking of this

http://tinyurl.com/288d4cs

 

[davides]

very smart ... I`m new in vba ... Understand me please

 

[namliam]

Try this see if you can figure it out from there:

Just wondering if you looked at this at all.

 

[davides]

Try this see if you can figure it out from there:

Sub testNotepad()
Open "C:\TestFile.txt" For Output As #1
Print #1, "Write some text"
Print #1, "Into a notepad"
Print #1, "text file"
Print #1, "make into " & vbNewLine & " make into two lines"
Close #1

End Sub

namliam ... it work your method but it put a character like this " ... at first line and the end line ... how can I remove this simbol?

now I have in txt file somethink like this:
"text1
text2
text3
endtxt"

Regards !

 

[namliam]

change Print to Write, though I thought Print didnt add the " but... can be wrong.