Need help deleting some specific files by an Excel macro

Guessed · #1 08-21-2022, 09:48 PM

The Kill command is being passed a filename but it doesn't know what path that file is sitting in. You might have more luck if you add that path in to the Kill command

Code:

Kill "D:\kalantari\miscellaneous\dailyreport01\" & MyFiles

soroush.kalantari · #2 08-22-2022, 08:04 PM

Quote:

Originally Posted by Guessed

The Kill command is being passed a filename but it doesn't know what path that file is sitting in. You might have more luck if you add that path in to the Kill command

Code:

Kill "D:\kalantari\miscellaneous\dailyreport01\" & MyFiles

Thank you very much. It worked and solved the problem.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word macro for deleting a line that starts with a specific character + deleting the line before	eduardb	Word	1	08-10-2022 03:17 AM
Excel Macro finding a specific word	ducky831	Excel Programming	3	09-17-2015 01:36 PM
Excel VBA Macro - Deleting Specific Data based on criteria	MD011	Excel Programming	3	12-10-2014 02:15 AM
Macro to copy specific columns in Excel from another spreadsheet	KD999	Excel Programming	1	07-20-2012 08:58 AM
excel 2010 not deleting tmp files on save/close	willbaker13	Excel	0	04-26-2012 05:08 PM