Thanks to Ron's code http://www.rondebruin.nl/zip.htm
i was able to unzip the files.
However, I need little modification and I am new to VB so i am not quiet
sure how to do so.

here's part of my code:
FileNameZip = "N:\Customer Counts\CEN.zip"
FolderName = "N:\Customer Counts\Tag"
FolderName = "N:\Customer Counts\Tag"
ShellStr = PathWinZip & "Winzip32 -min -e" _
& " " & Chr(34) & FileNameZip & Chr(34) _
& " " & Chr(34) & FolderName & Chr(34)
ShellAndWait ShellStr, vbHide

although it is extracting it to " Tag" folder, there are subfolders listed
so actually, it is extracting it to:
N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool
how would I delete the other folders? i want the files to extract to the
"Tag" folder.

Also, if the file already exist, I want it to overwrite it automatically.

Thank you!