I am tyring to fiigure outhow to use the Kill statement in VBA. My code is below. I am getting invalid use of propery" error
Private Sub Kill_Click()
Dim KillFile As String
KillFile = "c:\KILL\temp.x ls"
SetAttr KillFile, vbNormal
Kill KillFile
' Kill ("c:\KILL\temp. xls") (Tried this as well)
End Sub
c:\KILL\temp.xl s exists. I created it to test this out.
Any help would be appreciated. Thx
Private Sub Kill_Click()
Dim KillFile As String
KillFile = "c:\KILL\temp.x ls"
SetAttr KillFile, vbNormal
Kill KillFile
' Kill ("c:\KILL\temp. xls") (Tried this as well)
End Sub
c:\KILL\temp.xl s exists. I created it to test this out.
Any help would be appreciated. Thx
Comment