Useing the following
Sub KillFile()
Dim myFileName As String
myFileName = "C:\Parade\zzz.txt"
SetAttr myFileName, vbNormal
Kill myFileName ----- this line is yellow in debug
End Sub
Looking thru web could not find answer any help greatly appreciated
Thanks

Curt,

There's nothing wrong with the code. Are you sure that's the correct path?
What error message you getting?

Mike

"Curt" wrote:

Useing the following
Sub KillFile()
Dim myFileName As String
myFileName = "C:\Parade\zzz.txt"
SetAttr myFileName, vbNormal
Kill myFileName ----- this line is yellow in debug
End Sub
Looking thru web could not find answer any help greatly appreciated
Thanks

Run-time error '70':
Permission Denide

This is caused when the file you are trying to delete is in use by some one
else.


"Curt" wrote:

Useing the following
Sub KillFile()
Dim myFileName As String
myFileName = "C:\Parade\zzz.txt"
SetAttr myFileName, vbNormal
Kill myFileName ----- this line is yellow in debug
End Sub
Looking thru web could not find answer any help greatly appreciated
Thanks

Permission Denied error code 70
This same code is working in some other places.
In properties of file (zzz) type of file txt document opens with notepad
Location: C:\Parade


"Mike H" wrote:

Curt,

There's nothing wrong with the code. Are you sure that's the correct path?
What error message you getting?

Mike

"Curt" wrote:

Useing the following
Sub KillFile()
Dim myFileName As String
myFileName = "C:\Parade\zzz.txt"
SetAttr myFileName, vbNormal
Kill myFileName ----- this line is yellow in debug
End Sub
Looking thru web could not find answer any help greatly appreciated
Thanks

New to this there is no one else useing it is not on ?(server or whatever) So
if I follow you correcly it means another macro or part of program is
causeing this. If I am correct how would I find this hang up? Is there a way
when a part of program is run to disconnect use of this file to eliminate
this. Your answer about use is best I've had to understand.
Thanks

"Kent Prokopy" wrote:

Run-time error '70':
Permission Denide

This is caused when the file you are trying to delete is in use by some one
else.


"Curt" wrote:

Useing the following
Sub KillFile()
Dim myFileName As String
myFileName = "C:\Parade\zzz.txt"
SetAttr myFileName, vbNormal
Kill myFileName ----- this line is yellow in debug
End Sub
Looking thru web could not find answer any help greatly appreciated
Thanks