Thread: Delete an entire folders contents (or just Excel files)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DejaVu[_67_] DejaVu[_67_] is offline
external usenet poster
  
Posts: 1
Default Delete an entire folders contents (or just Excel files)

Is it possible to delete the entire contents of a folder with the VBA?
I'd like to be able to delete either all of the files out of a folder
or delete all the Excel files out of a folder. I know I can use
Code:
--------------------
Kill "C:\Test Folder\TestBk.xls"
--------------------


I assume that I can use some sort of loop to find all the files in a
folder and delete them, but is it possible to Kill an entire folder's
contents???

TIA
DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=531060

Reply With QuoteReply With Quote