Q:

Kill path file not found

I am trying to delete all files in the below folder. However error comes up as 

run time error 75: path/file not found

However a couple of things to note:

It does delete some files, but the same ones it never deletes
The path does exist

Code: 
Sub deleteprevfixing()
    'First delete file contents
    Dim aFile As String
    aFile = "R:\samsfiles\sam\!test\*.*"

    If Len(Dir$(aFile)) > 0 Then
         Kill aFile
    End If
End Sub

A:

All sorted - thanks to all. It was because I had to turn off the "Are you sure you want to permanently delete this file?" dialog when deleting from a network share or mapped drive.
Here is a solution how to do it (copied from source below)

Map a network drive to the network share you want to use. Make sure
that the drive is re-connected on logon.  
Browse to C:\users\<username>. 
Right-click on one of the folders in this location (any
folder such as "links") and click properties. 
Select the Location tab. 
Click Move, browse to root of the drive you mapped in step 1,
and click Select Folder. 
Click Ok and click yes in the dialogue box
that appears.

Please see attached for original thread

