I am launching Excel from a DOS command line along with the file to be opened as follows:-


c:\path\excel c:\path1\filename.xls

This works fine, but I wish to force excel to open this as read only. Is there a command line switch or other means of doing this?

My first inclination is to suggest saving the workbook as readonly. Do this by going into the XL-[File]-[Save As]

In the Save as dialogue box go to [Tools]-[General Options], in options enter a password in the to Modify box. This will require the user to enter a password to allow full access or give a read only choice.

Cheers

Matt

I dont have an opportunity to do that with the file (it is created from another application). However I think i have found the syntax which is

c:\path\excel -R filename.xls

But I now need to open two files, one Read Only and the other not Read/Write.

OK, heres some more I found.

if I do:-
excel file1 file2 'then both open up Read Write
excel -R file1 file2 'then both open up as Read only
excel file1 -R file2 'then file1 opend RW and file2 opend up RO
excel file1 file2 -R 'then both open Read Write

What I need is file1 to be Read Only and file2 to be Read Write.
The reason is file2 will be the active window once the files have been opened.