cmd /c del to delete file

[tiredofit]

I want to use the cmd /c del command to delete a file, instead of Kill.

This works:

  Dim Loc As String
    
    Loc = "C:\MyFolder\abcdef.xlsm"
    
    Dim cmd As String


    cmd = "cmd /c del " & Loc
    
    Shell cmd

but if the filename contains a space like this, it fails

    Dim Loc As String
    
    Loc = "C:\MyFolder\abcde f.xlsm"
    
    Dim cmd As String

    
    cmd = "cmd /c del " & Loc
    
    Shell cmd

How can I make it work when the filename contains spaces?


Thanks

 

[tyija1995]

I think you have to put the filename in double quotes too for it to work with spaces.

 

[RoryA]

As in:

cmd = "cmd /c del """ & Loc & """"

 

[tiredofit]

I think you have to put the filename in double quotes too for it to work with spaces.

As in:

cmd = "cmd /c del """ & Loc & """"

Afraid it didn't work.

If I wasn't using variables, then doubling up the quotes does work, ie

strcmd = "cmd /c del C:\MyFolder\" & """abcde f.xlsm"""

 

[tyija1995]

What about this code: (Altered your first post code slightly)

  Dim Loc As String
  Dim fileName As String
  
  fileName = "abcde f.xlsm"
    
    Loc = "C:\MyFolder\" & Chr(34) & fileName & Chr(34)
    
    Dim cmd As String


    cmd = "cmd /c del " & Loc
    
    Shell cmd

 

[tiredofit]

What about this code: (Altered your first post code slightly)

  Dim Loc As String
  Dim fileName As String
  
  fileName = "abcde f.xlsm"
    
    Loc = "C:\MyFolder\" & Chr(34) & fileName & Chr(34)
    
    Dim cmd As String


    cmd = "cmd /c del " & Loc
    
    Shell cmd

Thanks, yes this version worked.

 

[RoryA]

Afraid it didn't work.

Works fine for me - what happened when you tried it?

 

[tiredofit]

Works fine for me - what happened when you tried it?

It didn't crash but didn't delete the file either!

 

[RoryA]

Any error would appear briefly in the command prompt window before it disappeared, so you probably wouldn't see it.

 

[tiredofit]

Thanks