How do I select "Read Only"

[iashorty]

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?

 

[Jim Thomlinson]

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

 

[Tom Hutchins]

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]

Thanks Jim. It worked beautifully.

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

 

[iashorty]

Thanks, Tom. Indeed it was the first item.

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