write to text file without quotes in VBA

bbcpjc · Apr 24th, 2002, 04:05 AM

Sample code

Open "C:myfile.txt" For Output As #1 Len = 120
record = "Message1"
Write #1, record
record = "Message2"
Write #1, record

Is there a way of not having quotation marks in the file?

bergy · Apr 24th, 2002, 06:45 AM

Try the 'print' command instead of the 'write' command. Also, it's best to close your file.

Sub Print_Test()
Dim record As String
Open "C:myfile.txt" For Output As #1
record = "Message1"
Print #1, record
record = "Message2"
Print #1, record
Close #1
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 04:05 AM	#1
bbcpjc New Member Join Date: Apr 2002 Posts: 11	Sample code Open "C:myfile.txt" For Output As #1 Len = 120 record = "Message1" Write #1, record record = "Message2" Write #1, record Is there a way of not having quotation marks in the file?

Apr 24th, 2002, 06:45 AM	#2
bergy Board Regular Join Date: Apr 2002 Posts: 112	Try the 'print' command instead of the 'write' command. Also, it's best to close your file. Sub Print_Test() Dim record As String Open "C:myfile.txt" For Output As #1 record = "Message1" Print #1, record record = "Message2" Print #1, record Close #1 End Sub