LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to open same name files in different folders in Excel? DrDisk7 Excel Discussion (Misc queries) 1 April 1st 08 02:35 PM
Password protect Excel and Word FOLDERS (not just files) Hedges Chandler Excel Discussion (Misc queries) 1 November 15th 05 07:23 PM
Moving files between folders using VBA in Excel Paul Excel Programming 2 August 5th 05 02:25 PM
Open Excel files/folders animalfriend7 Excel Discussion (Misc queries) 1 June 23rd 05 11:57 PM
delete all the contents (sub folders and files) in the temp folder Joseph Excel Discussion (Misc queries) 0 June 6th 05 08:01 AM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"