Command line switch to open file as read-only?

  • Thread starter Thread starter Mrnobody
  • Start date Start date
M

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!
 
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
 
Back
Top