Delete existing before running Open "c:\MyFile. txt" For Output As #1 ?

[MLH]

Is it good programming practice to delete existing file before running
Open "c:\MyFile. txt" For Output As #1 ???

IE, I already have a file c:\MyFile.txt on disk and I launch
Open "c:\MyFile. txt" For Output As #1 ==> VBA is supposed to
overwrite whatever WAS there with the new contents - right? And
if that is true, does it matter whether I delete the existing file
prior to running the Open statement?

[Danny J. Lesandrini]

I generally like to clean up, either before a process or after it ends,
for files that are disposable. Try something like this ...

If Dir("c:\MyFile. txt") <> "" Then Kill("c:\MyFile .txt")

--

Danny J. Lesandrini
dl*********@hot mail.com
http://amazecreations.com/datafast
"MLH" <CR**@NorthStat e.net> wrote in message news:as******** *************** *********@4ax.c om...

Is it good programming practice to delete existing file before running
Open "c:\MyFile. txt" For Output As #1 ???

IE, I already have a file c:\MyFile.txt on disk and I launch
Open "c:\MyFile. txt" For Output As #1 ==> VBA is supposed to
overwrite whatever WAS there with the new contents - right? And
if that is true, does it matter whether I delete the existing file
prior to running the Open statement?

[MLH]

On Tue, 13 Dec 2005 11:01:36 -0700, "Danny J. Lesandrini"
<dl*********@ho tmail.com> wrote:

I generally like to clean up, either before a process or after it ends,
for files that are disposable. Try something like this ...

If Dir("c:\MyFile. txt") <> "" Then Kill("c:\MyFile .txt")

xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxx
Yep. That's good practice.

[Douglas J. Steele]

Opening a file As #1 isn't good programming practice!

Dim intFile As Integer

If Len(Dir("c:\MyF ile.txt")) > 0 Then
Kill "c:\MyFile. txt"
End If

intFile = FreeFile()
Open "c:\MyFile. txt" For Output As #intFile

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MLH" <CR**@NorthStat e.net> wrote in message
news:as******** *************** *********@4ax.c om...

Is it good programming practice to delete existing file before running
Open "c:\MyFile. txt" For Output As #1 ???

IE, I already have a file c:\MyFile.txt on disk and I launch
Open "c:\MyFile. txt" For Output As #1 ==> VBA is supposed to
overwrite whatever WAS there with the new contents - right? And
if that is true, does it matter whether I delete the existing file
prior to running the Open statement?

[MLH]

Good point. I agree.
xxxxxxxxxxxxxxx xxxxxxxxxxx

Opening a file As #1 isn't good programming practice!

Dim intFile As Integer

If Len(Dir("c:\MyF ile.txt")) > 0 Then
Kill "c:\MyFile. txt"
End If

intFile = FreeFile()
Open "c:\MyFile. txt" For Output As #intFile