Ron de Bruin has lots of code samples for working with zip files:
http://www.rondebruin.nl/tips.htm
look for zip

Gary Keramidas wrote:

i'm using the shell command to unzip a file. problem is, i need to know when the
file is accessible.
using a loop such as:

Do Until Dir(fpath & "*.dat") < ""
Loop

doesn't really work, because the file exists, but it's not completely unzipped
and is inaccessible. i could use a wait, but every pc is different and i don't
want to use some arbitrary number of seconds.

so, what's the best way to tell when the unzipping procedure is complete?

--

Gary Keramidas
Excel 2003

--

Dave Peterson