Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using winxp pro and msoffice 2003
I am using this code to open a workbook and it does the job I am asking it to do alright, only what I really want to do is open a copy of this workbook, and set the read only attribute to false. I tried putting this at the end of the statement ;read only = false but that doesn't work. Workbooks.Open ("C:\Documents and Settings\joanne\Desktop\ _ Linking Project\Outlook Master Pricing.xls") Could someone please show me the proper syntax for opening a wb as a 'copy of wb' and setting the read only attribute to false? Thank you for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Open workbook macro- find correct month to open? | Excel Programming | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming |