I'm a newbie, so hope I can explain myself clearly. I'm using Access 97. I have 1000+ password protected zip files within a directory. I want to write VBA code to unzip all of them, place them into a temp directory, and then import them. How do I do that? Thanks for all your help!