Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Kill'
Hi,
I've read and re read many posts on this subject- I do not want to delete the file to the recycle bin just remove it completely so am using... Sub DeleteThisFile() Dim DeleteFile As String DeleteFile = ActiveWorkbook.FullName ActiveWorkbook.Close On Error Resume Next kill DeleteFile End Sub The user need not know that the fiule is being deleted... however when trying to run it I get the following 450 error 'Wrong number of arguments or invalid property assignment' Am I missing something dreadfully obvious? It has been a long day... Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Kill Macro | Excel Discussion (Misc queries) | |||
On time kill | Excel Discussion (Misc queries) | |||
Kill variables | Excel Programming | |||
kill worksheets | Excel Programming | |||
AutoFill KILL | Excel Programming |