View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DBM[_2_] DBM[_2_] is offline
external usenet poster
 
Posts: 4
Default Excel Macro to open password protected workbooks?

I've got a macro that opens other Excel workbooks to pull specific data that
constantly changes. These workbooks are password protected. Is there language
I can put in the macro to fill the password field? Right now when I run the
macro, I need to manually enter the password for each workbook that the macro
opens.

Thanks!
Darren