Unzip all files in a specific folder and move CSV files to a different specificed folder

Hi all! I have referenced this site for help on multiple occasions, but this is my first post. I hope I am following all correct protocol!

I am trying to use vba to loop through several zipped files within a specific folder, unzip each, and move (or copy) the CSV to a separate zipped folder. I would like to re-name the CSV file to the name of the zipped file, but as a CSVxl format.

I have looked at several posts and tried what appears to be similar code. However, I just cannot get it to work... :/ Any help would be greatly appreciated!

Thank you!
Brooke

I have the same challenge. Being a novice at VBA I am struggling to get the multiple file selection right