View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matilda Matilda is offline
external usenet poster
 
Posts: 57
Default Unzip all encrypted files in a folder with known passwords

Dear Gurus,

I found the link to Ron de Bruin's excellent code for unzipping files in
this discussion group and it works brilliantly.

I now have the need to unzip some archived files which were initially
encrypted for email transmission. I have the passwords, and have written the
code up to the point of passing the password. Cannot find reference to this
problem anywhere on the net (wonder why :-)) ) but since my need is strictly
ethical, thought I would post it here.
As things are, I run my code, then sit and tap <ctrl v <enter each time
the prompt appears for each file opened. Erk.

Any alternatives?

TIA,


Matilda