Link to excel sheet that is part of a winzip file and pw protected

[rayted]

Hi guys,



Is it possible for me to create a link to an excel spreadsheet which is updated daily into my database that is located in a similar order to this:

folder > folder > folder > folder > folder > prompt box "click ok", excel file is there in a winzip folder, click on it and input the password which is the same for each file...

I`m assuming a macro or VBA could be possible? I would have no idea where to begin.

*UPDATE* OR Can someone instruct me on how to 'link to a folder' - I am able to find my way through to finding the folder, but then I can't see the winzip folder.. so it seems access does not know what winzip is? or is there a way i can instruct access to find the winzip folder?

Any suggestions guys?

R.

[ranman256]

Unzip the excel file.