Need macro to Zip/Unzip

Hi Pro's,

Am in a process of doing an automation using Excel. The problem here is that i have two buttons in my Excel page.. One as 'Zip' and another as 'Unzip'. I will be having the file path or the folder path in two different cells in a sheet depending on whether to zip or unzip. So when i click the Zip/Unzip button the macro should either zip or unzip the path or the file accordingly.

Hope it is a tricky thing. Kindly need a help on this.

Regards,
Vikan
Necessity is the mother of Invention

Thanks for your quick response. I will try the code and update on the same