Download_unzip_Consolidate_data in excel

[exceldissciple]

Hi All,

Very Good Morning!

Iam new to excel and iam comfortable with pivots and formulae. However, i have challenge now, where i need to download zip file from outlook on a daily basis, unzip extract the text file and collate the data in excel DB.

I have tried all the combinations to put an automatic method to do an above mentioned task, however, i couldnt. I need a help in getting a VBA code to do this task on a daily basis.

Thank you
Exceldissciple

 

[exceldissciple]

Any help on the above will be a great help to me