Unzip Then Delete Or Overwrite Files

I've struggled to find the code to unzip files using VBA but I finally found it and it works (using Shell).

The problem is that I want to unzip all zip files in a folder but my zip files contain 3 files:

1 csv file that I want to keep and 1 xml and 1 txt file that I want to delete.

I can't just unzip everything and deal with the txt and xml later because the xml and txt files all have the same name. So if I don't do anything, I have a series of overwriting messages prompting me to click yes or no. So what I want is either to delete xml and txt one by one after they are created or get rid of the overwriting prompt. I've tried to put a kill or delete file just after the unzip command but it doesn't work - it's telling me that the txt file doesn't exist (should I add some sort of refreshing command ?) and I couldn't find anything on google about overwriting text or xml files.