Command line switch to open file as read-only?

[Mrnobody]

I have a batch script which I use to open a spreadsheet when I logon in the morning. When
the batch file opens the spreadsheet, I get a requestor asking me if I want to open the
file as 'Read Only'(Other people use the spreadsheet and have it open). I'd like to bypass
that requestor entirely. Is there a command line switch that will open the file as
read-only? Please reply to the group as my email addy is, of course, invalid...

Thanks!

 

[Dave Peterson]

Take a look at "startup switches" inside Excel's help.

From there, you'll see you can add "/r" without the quotes to your command line
to have the workbook open readonly.

c:\yourpathtoexcel\excel.exe /r c:\yourpathtoyourworkbook\book.xls