Open File Read Only
 

Should be really easy, why wont this work...

Workbook.Open:=("N:\Common\Resale Pricing
Team\Templates\Template -
VendorReleaseDetail.xls",0,ReadOnly:=True)

VBA Help dosent give example of opening read only, and
their help as you type is fairly worthless unless you
already have VBA experience. Little help please :)

c-

Open File Read Only
 

Workbooks.Open "c:\YourFilename.xls", False, True

--
Jim Rech
Excel MVP
"Chris" wrote in message
...
Should be really easy, why wont this work...

Workbook.Open:=("N:\Common\Resale Pricing
Team\Templates\Template -
VendorReleaseDetail.xls",0,ReadOnly:=True)

VBA Help dosent give example of opening read only, and
their help as you type is fairly worthless unless you
already have VBA experience. Little help please :)

c-