Hypelink not working with zipped file

Hai my dear friends

Any help will be greatly appreciated

I have one macro which will collect files from the location mentioned in the cell F1 and shows all files inside that particular location
the problem is that it does not go inside the subfolder called EOD_16082013 which is a zipped one ..
i want a file called LN167 which is inside the EOD_16082013 zipped file.

but it comes up to D:\Nana\EOD and it does not further go inside later i found that EOD is a zipped file

i cant unzip it because it is a large file and i have to update and save everyday a new EOD file
is there any solution to open that LN167 file keeping this folder EOD as remain zipped

your assistance is really worthwhile

Sincerely
Narayanan