radam
06-14-2011, 03:59 AM
I have a list of path names (column A) and file names (column B) looking for a macro that will delete all files on this list.
PathFile NameC:\Users\john.doe\Desktopa.pdfC:\Users\john.doe\Desktopb.xlsmC:\Users\j ohn.doe\Desktop\other stuffc.xlsxC:\Users\john.doe\Desktop\other stuffa.xlsxC:\Users\john.doe\Desktop\other stuffb.xlsx
Looking for a macro that will delete all files in this list where the number of files will vary. If the files are in use the macro should skip that particular file and continue to delete the rest.
PathFile NameC:\Users\john.doe\Desktopa.pdfC:\Users\john.doe\Desktopb.xlsmC:\Users\j ohn.doe\Desktop\other stuffc.xlsxC:\Users\john.doe\Desktop\other stuffa.xlsxC:\Users\john.doe\Desktop\other stuffb.xlsx
Looking for a macro that will delete all files in this list where the number of files will vary. If the files are in use the macro should skip that particular file and continue to delete the rest.