Using an Excel sheet for batch delete
HI All
I have an Excel worksheet with a list of file names in column A.
I'd like to use this list to look into a named directory (perhaps built
in to the routine , or entered via a popup) and delete files of the same
name in turn.
Once a file is deleted , then the routine would go back to Excel and
look up the next file name in the column for the next delete , and so on
until it reaches the end of the list.
Can someone help with this , please?
Grateful for any advice.
Best Wishes
|