Writing text file

[John]

Hi

When I write a string in a text file using below code my strings are
enclosed in double quotes. How can I avoid the quotes and get just the text?

Thanks

Regards

St = "My String"
Open "MyFile.txt" For Append As #1
Write #1, St
Close #1

 

[Ken Snell [MVP]]

Use Print method instead:

St = "My String"
Open "MyFile.txt" For Append As #1
Print #1, St
Close #1

 

[John W. Vinson]

Hi

When I write a string in a text file using below code my strings are
enclosed in double quotes. How can I avoid the quotes and get just the text?

Thanks

Regards

St = "My String"
Open "MyFile.txt" For Append As #1
Write #1, St
Close #1

Use Print #1 instead of Write #1. See the VBA help for the two methods.

 

[Bob Quintal]

Hi

When I write a string in a text file using below code my strings
are enclosed in double quotes. How can I avoid the quotes and get
just the text?

Thanks

Regards

St = "My String"
Open "MyFile.txt" For Append As #1
Write #1, St
Close #1

Try Print #1, st instead of write.

 

[Bob Quintal]

Try Print #1, st instead of write.

Better yet, open the file in binary mode and use Put #1,,St
statements.

I create a few HTML pages this way.