
Tips.Net > ExcelTips Home > Macros > Deleting a File in a Macro
Summary: Need to delete a file within your macro? If you know the path and name of the file, it is easy to do with a simple command. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
Sometimes you may use a macro to create temporary files which you later need to delete. Similarly, you may need to just delete a file within a macro. You can accomplish this task using the Kill command. This is a holdover from other versions of BASIC. The syntax is:
Kill File
where File is the full path and file name of the file you want to delete. When you delete a file in this manner, the file is not moved to the Windows Recycle bin; instead, it is immediately deleted from your drive.
If desired, you can also use wildcard characters in the File specification. For instance, if you wanted to delete all the files in the current directory that end in the TMP extension, you could use a command like this:
Kill "*.tmp"
Tip #2450 applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Got the Time? If you work with either times or dates in Excel, you really need ExcelTips: Times and Dates. Everything you need to know about slicing, dicing, and generally working with times and dates.
No, not that type of date. If you need to do any types of work with calendar dates, Excel has the tools you need. Learn how to use those tools the easy way. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site