View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default I need to remove passwords from a list of files.

Hi Conan,

See JE McGimpsey at:

http://www.mcgimpsey.com/excel/fileandvbapwords.html


---
Regards,
Norman


"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

I have a list of *.XLS files in a folder. Each one has a password to open
the file (Save As...ToolsGeneral Options...). The password is the same
on each file.

I need to remove the password on each file. Is there a way to create a
macro that will do this for me? Sample code is welcomed.

Any help will be greatly appreciated,

Conan Kelly