Open Excel Document as ReadOnly

[Ahankhah]

Hi all,

I know the Autolisp functions to open an Excel document:

(defun MT:Open-Excel-File (%ExcelFileName%)
 (vlax-invoke-method (vlax-get-property (vlax-get-or-create-object "Excel.Application") 'WorkBooks) 'Open %ExcelFileName%)
)

But don't know how to open it as ReadOnly.

How is it possible?

 

I appreciate any help.

[Ahankhah]

(defun MT:Open-Excel-File (%ExcelFileName%)
 (vlax-invoke-method (vlax-get-property (vlax-get-or-create-object "Excel.Application") 'WorkBooks) 'Open %ExcelFileName% nil T)
)

The correct code to open File as ReadOnly.

[Tharwat]

1 hour ago, Ahankhah said:

(defun MT:Open-Excel-File (%ExcelFileName%)
 (vlax-invoke-method (vlax-get-property (vlax-get-or-create-object "Excel.Application") 'WorkBooks) 'Open %ExcelFileName% nil T)
)

The correct code to open File as ReadOnly.

 

You should have given the credit to @VovKa who helped you with it.  

 

https://www.theswamp.org/index.php?topic=56623.msg603840#msg603840

[Ahankhah]

On 3/5/2021 at 7:17 PM, Tharwat said:

 

You should have given the credit to @VovKa who helped you with it.  

 

https://www.theswamp.org/index.php?topic=56623.msg603840#msg603840

Tharwat, yes, you are right. I appreciate greately Vovka's help and thanked him in the your mentioed address.

 

Edited April 7, 2021 by Ahankhah

[kirby]

Old post, but always a good idea to review the Microsoft Office/Excel API reference for details on methods and properties when trying to do this kind of thing

 

https://docs.microsoft.com/en-us/office/vba/api/excel.workbooks.open