How to Run Excel in Readonly mode?

[Milkmannetje]

Hi there,

i'm looking for a way to open an Excel file readonly, since the file always is edited.

The script is opening the file this way:

ShellExecute($FileName, "", @ScriptDir, "", @SW_MAXIMIZE)

But I don't know a way to pass through the Readonly Parameter of Excel.

(The specific file needs to be reopened every 10 minutes. I don't want any dialogboxes that asks me questions about the file is being in use...)

Who can give me some hints?

Thanks!

[johnmcloud]

Read here:

http://office.microsoft.com/en-us/excel-help/command-line-switches-for-excel-HA010158030.aspx

Tips: /R

[water]

You could try the Excel UDF that comes with AutoIt. Or check my Alpha version of the Excel UDF rewrite.

[water]

To open a workbook read-only set parameter $fReadOnly to True. Extract from the help file:

_ExcelBookOpen($sFilePath [, $fVisible = 1 [, $fReadOnly = False [, $sPassword = "" [, $sWritePassword = ""]]]])