Excelcom.au3 - findout if spreadsheat is in Readonly mode

[hazed]

I need to update a shared Spreadsheet. Unfortunately other's may have it opened already. Using Excelcom.au3 I open, update and get out. But sometimes when i open it it is in a readonly mode, if it is i need to do something else. Is there a easy way to find out at or shortly after opening a spreadsheat with excom.au3 if one has Read/Write access.?

[DW1]

$att = FileGetAttrib( "C:\test.txt" )
If StringInStr( $att, "R" ) Then MsgBox(0, "Test", "File is read only" )

Maybe I misunderstood your question.

[big_daddy]

Try this...

#include <ExcelCOM_UDF.au3>

$sFilePath = @ScriptDir & "\Test.xls"

$oWorkbook = _ExcelBookOpen($sFilePath)

If $oWorkbook.ReadOnly Then
    MsgBox(0, "", "Your workbook is in read only mode.")
EndIf

ExcelCOM_UDF.au3

Edited November 20, 2007 by big_daddy
Added link for library

[alsolh]

Try this...

#include <ExcelCOM_UDF.au3>

$sFilePath = @ScriptDir & "\Test.xls"

$oWorkbook = _ExcelBookOpen($sFilePath)

If $oWorkbook.ReadOnly Then
    MsgBox(0, "", "Your workbook is in read only mode.")
EndIfoÝ÷ Úêå