View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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-