Unzip file Automatically without search

Hi All

Hope you are all well.

I have a macro that saves zip files automatically from outlook every day and saves over those zip files (which I want).
But now I need to unzip those files and save their csv files in a different folder. I will be saving over the same csv files everyday.

(I have 5 zip files saved and named and each file contains just 1 csv file)

I have had a look at Ron de Bruin's code but he requires you to open the and search for the zip file.
I would like this to unzip and save automatically without having to use "Application.Getopen".

Please help.