write to text file without quotes in VBA

[bbcpjc]

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]

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

 

[basb87]

17 years later --> Thanks. I just happen to need this info.

 

[mmoose]

19 years later --> Thank you, just what I needed. Don't write, print!

 

[PaulMac1]

cool... 19.3 years later...

 

[Informer]

Thanks a lot... 19 years and 4 months later

 

[throwaway22]

Thank you. Twenty years and four months later, this is the answer and that still works.

 

[Elf_this]

Thank you.. 21 years 4 months later the answer works perfectly.