How do I select "Read Only"
 

I am writing a macro that needs to open another file that is password
protected in "Read Only", copy a sheet into my current file and close the
file I am copying from. How do I write the string to select "Read Only" from
the password window?

How do I select "Read Only"
 

Workbooks.Open Filename:="C\Text.xls", ReadOnly:=True, _ Password:="MyPassword"
--
HTH...

Jim Thomlinson


"iashorty" wrote:

I am writing a macro that needs to open another file that is password
protected in "Read Only", copy a sheet into my current file and close the
file I am copying from. How do I write the string to select "Read Only" from
the password window?

How do I select "Read Only"
 

If you want to open the file in read-only mode, ReadOnly is one of the
options for the Workbooks.Open method:

Workbooks.Open Filename:="D:\Data\book1.xls", _
Password:="abc", ReadOnly:=True

If you meant that the workbook was save with the read-only recommnded
option, you can tell Excel not to display the read-only recommended message:

Workbooks.Open Filename:="D:\Data\book1.xls", _
Password:="abc", IgnoreReadOnlyRecommended:=True

Hope this helps,

Hutch

"iashorty" wrote:

I am writing a macro that needs to open another file that is password
protected in "Read Only", copy a sheet into my current file and close the
file I am copying from. How do I write the string to select "Read Only" from
the password window?

How do I select "Read Only"
 

Thanks Jim. It worked beautifully.

"Jim Thomlinson" wrote:

Workbooks.Open Filename:="C\Text.xls", ReadOnly:=True, _ Password:="MyPassword"
--
HTH...

Jim Thomlinson


"iashorty" wrote:

I am writing a macro that needs to open another file that is password
protected in "Read Only", copy a sheet into my current file and close the
file I am copying from. How do I write the string to select "Read Only" from
the password window?

How do I select "Read Only"
 

Thanks, Tom. Indeed it was the first item.


"Tom Hutchins" wrote:

If you want to open the file in read-only mode, ReadOnly is one of the
options for the Workbooks.Open method:

Workbooks.Open Filename:="D:\Data\book1.xls", _
Password:="abc", ReadOnly:=True

If you meant that the workbook was save with the read-only recommnded
option, you can tell Excel not to display the read-only recommended message:

Workbooks.Open Filename:="D:\Data\book1.xls", _
Password:="abc", IgnoreReadOnlyRecommended:=True

Hope this helps,

Hutch

"iashorty" wrote:

I am writing a macro that needs to open another file that is password
protected in "Read Only", copy a sheet into my current file and close the
file I am copying from. How do I write the string to select "Read Only" from
the password window?