Open WB

[Joanne]

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

 

[Bob Phillips]

what do you mean by a copy of wb? Do you already have it open?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Joanne]

Bob
No, it is not yet open. It is a master pricing ws and I don't want any
changes made to it - so I want to open a copy of it for my user, run my code
on the copy to hide info user does not need for current job, allow user to
manipulate the rest of the data, all the while the master is safe. When user
is done with the job, the 'copy of the workbook' is dumped.

I think that my code will not run on the master anyway (in my tests using an
old version of the master) because the master is 'read only' - am I correct
in thinking that this is the reason I cannot hide any of the columns. That is
why I need to know how to open the 'copy of wb' and change the attribute to
'read' from 'read only'.

Bob, thank you for your time and consideration of my little dilemma. I sure
appreciate it a lot
Joanne

 

[NickHK]

Is the file is marked as read-only in Windows: Right-click on the file in
Explorer, select properties, at the bottom, is the Read Only attribute set ?
If so, you can open it and make any changes you want, but the user will not
be able to save to file as that name; they will be able to do a .SaveAs, but
that will not affect the original.

Sounds like you may have the workbook and/or the worksheet(s) protected;
Tools>Protection.

NickHK