Delete all files listed in Column A

Hello,

I have been looking, and tried a few scripts, all seem to not work.

i tried the following code below, it doesn't work if the file name has spaces i'm guessing, but it also doesn't really tell me what it is doing ha, just my guess based off a few test files. Any help would be appreciated. i have about 42k files that were hit with a crypto virus that i need to delete.

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

What strings are in columns A and B? Can you give one or two examples? That might be your problem. Spaces in the file names will not cause a problem the way this is written.

Excel VBA is a kind of an oddball way to solve this. You could use this list of files to generate a Windows .bat file and run that.

It doesnt have to be excel, just what im used to. Hiw would the .bat file be written?

The data in A is literally the entire path & filename.ext

Originally Posted by mkn95u0

The data in A is literally the entire path & filename.ext

Then what is in column B that you are appending to it?

If you're comfortable with VBA no reason not to do it, especially since you have the list of filenames in Excel. You're almost there.

Originally Posted by 6StringJazzer

Then what is in column B that you are appending to it?

If you're comfortable with VBA no reason not to do it, especially since you have the list of filenames in Excel. You're almost there.

nothing. it's like this:

Please Login or Register  to view this content.

this script worked for about 280 files, after that, just doesn't do anything. all of them are the same format, just different paths

It might help to put some diagnostics into the code, since we can't test it with your files. This will write information into column C for each file. See changes in red.

Please Login or Register  to view this content.