View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Help: Error when opening a password protected workbook

I'm hoping you have newworkbook.xls or something.

"sam" wrote:

Hi All,

I am trying to pull some info from a password protected workbook to populate
some fields in my userform which is in a seperate workbook but it gives me an
error:
"C:\Documents\NewWorkbook" cannot be found. Check your spelling, or try a
different path

Here is my code to access the workbook:
Workbooks.Open "C:\Documents\NewWorkbook", False, False, , "password12"

Am i missing something here?

Thanks in Advance.