Excel VBA Notepad - overwrite possible?

**RiskyP** · 01-15-2013, 03:49 PM

Hello,

been trying for ages to no avail!

can i use VBA to:
Open a Notepad File (.html)
Clear text
(or overwrite all text)
Paste a value/string (have no problem defining string ect...)

Thanks
P

**sullivan372** · 01-15-2013, 04:01 PM

Any reason not to just over write the whole file using the FileSystemObject? Check out the creating a new text file section here: http://www.wiseowl.co.uk/blog/s211/writeline.htm

You should be able to just write over the file, rather than open, clear, and writeline.

**shg** · 01-15-2013, 04:03 PM

Sub x()
    Const sFile     As String = "C:\myPath\myFile.txt"
    Dim iFile       As Integer

    iFile = FreeFile()
    Open sFile For Output As #iFile
    Write #iFile, "Risky business"
    Close iFile
End Sub