Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detecting password protection on zip files in Excel VBA

Status
Not open for further replies.

dvdmovieman

Programmer
Mar 14, 2003
2
US
I'm trying to determine if a .zip file is password protected using Excel VBA code.

We have implemented automation that cycles through hundreds of files a day, and we don't want to get hung up with the "enter password" dialog box that appears when you attempt to open the file.

Ultimately, we want the Excel code to just return a boolean variable so we can tell the program how to proceed.

Can anyone please help???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top