QBR Crawling Inbox into Zipped File

Hi all,

I have been using VBA to crawl my inbox looking for an excel report. I have attached the code that I use for this method, that works properly. Recently some of the report have come in a zipped file, does anyone know how to modify the code to accommodate for this?

Thank you in advance,

Jocelyn