ExcelBanter - View Single Post - eliminating quotation marks when writing to a text file

JE McGimpsey

Take a look at

http://www.mcgimpsey.com/excel/textf...ml#csvnoquotes

In article ,
margrabe wrote:

Hi. Below is a very simple macro.

Sub WriteText()

Open "test.html" For Append As #1
Write #1, "<HTML</HTML"
Close

End Sub

All I want to do is create an HTML file based on user inputs. But when
I run the above code, the file displays the following: "". The source
code displays: "<HTML</HTML". How do I keep those quotation marks
from showing up?

Thanks.

Billy

---
Message posted from http://www.ExcelForum.com/