Excel VBA中实现删除D:\Test\temp目录下的所有文件夹和文档
请给出具体代码
第1个回答 2014-10-15
Sub Test()
Dim fs As Object
Set fs = CreateObject("scripting.filesystemobject")
fs.deletefile "D:\Test\temp\*.*"
fs.deleteFolder "D:\Test\temp\*.*"
End Sub
Dim fs As Object
Set fs = CreateObject("scripting.filesystemobject")
fs.deletefile "D:\Test\temp\*.*"
fs.deleteFolder "D:\Test\temp\*.*"
End Sub
第2个回答 2014-10-15
Sub mydel()
Shell "cmd.exe /c rd/s/q d:\test\temp\"
End Sub追问
Shell "cmd.exe /c rd/s/q d:\test\temp\"
End Sub追问
只删除D:\Test\temp目录下的所有,temp文件夹要保留
追答Sub mydel()
Shell "cmd.exe /c rd/s/q d:\test\temp\"
Shell "cmd.exe/c md d:\test\temp"
End Sub
Shell "cmd.exe/c md d:\test\temp" ---> 运行时错误 '53' 文件未找到
追答不好意思,少了一个空格
Sub mydel()
Shell "cmd.exe /c rd/s/q d:\test\temp\"
Shell "cmd.exe /c md d:\test\temp"
End Sub
你再试。