Hi,
I have this shell command in VBA
x = Shell("cmd.exe /c dir /Tw/S " & sPath & "*." & LCase(sFileExtension) &
" " & _
ThisWorkbook.Path & "\Directory.txt", 1)
which works fine, but i need to wait until it has finished running before
going to the next command

I use Sheets("Directory").Delete to delete this sheet but it asks if I
want to delete this sheets, how do I get rid of the message.

Thanks MarkS