Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to save /make excel file as read only?
Hello,
I need to save an excel file as a read only file for viewing from a website. How to save it as read only? I really need to save the file as an xml file. Excel already does that, and the xml file opens up inside IE. But I need that file to be read only. I am thinking that if I make the excel file read only - when I save it down as xml the xml will copy the read only attribute. But how to make the file read only? Thanks, Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to save /make excel file as read only?
With the file closed
Setattr "fullname" vbReadonly Regards, Peter T "Rich" wrote in message ... Hello, I need to save an excel file as a read only file for viewing from a website. How to save it as read only? I really need to save the file as an xml file. Excel already does that, and the xml file opens up inside IE. But I need that file to be read only. I am thinking that if I make the excel file read only - when I save it down as xml the xml will copy the read only attribute. But how to make the file read only? Thanks, Rich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to save /make excel file as read only?
Thanks. That worked perfectly
Rich "Peter T" wrote: With the file closed Setattr "fullname" vbReadonly Regards, Peter T "Rich" wrote in message ... Hello, I need to save an excel file as a read only file for viewing from a website. How to save it as read only? I really need to save the file as an xml file. Excel already does that, and the xml file opens up inside IE. But I need that file to be read only. I am thinking that if I make the excel file read only - when I save it down as xml the xml will copy the read only attribute. But how to make the file read only? Thanks, Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make an Excel 2007 file read-only? | Excel Discussion (Misc queries) | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
How can I save an Excel file which says it's a Read only to a CD? | Excel Discussion (Misc queries) | |||
How to make the column in the excel file as read-only? | Excel Programming | |||
Make excel open file without Read Only dialog | Excel Discussion (Misc queries) |