View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Remove passwords from many workbooks

ps. Watch for line wrap on he

Set tempWkbk = Workbooks.Open _
(Filename:=myPath & myFiles(fCtr), Password:=myPWD(pCtr))