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.

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.

You didn't include the extension (.xls, .xlsm, .xlsx, ...)



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.

--

Dave Peterson

I tested and found NewWorkbook will open without the extension included
in the code.

2003 and 2007 testing.


Gord

On Mon, 26 Oct 2009 17:39:35 -0500, Dave Peterson
wrote:

You didn't include the extension (.xls, .xlsm, .xlsx, ...)



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.

Maybe it was a different spelling error.

In WinXP, it's "C:\my documents" (vista uses C:\documents, IIRC).

Gord Dibben wrote:

I tested and found NewWorkbook will open without the extension included
in the code.

2003 and 2007 testing.

Gord

On Mon, 26 Oct 2009 17:39:35 -0500, Dave Peterson
wrote:

You didn't include the extension (.xls, .xlsm, .xlsx, ...)



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.

--

Dave Peterson