Topic: How to open Excel documents as ReadOnly in Visual-Lisp

[ahankhah]

Hi all,

I know the Autolisp functions to open an Excel document:

Code - Auto/Visual Lisp: [Select]

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

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

How is it possible?

 

I appreciate any help.

[VovKa]

Code: [Select]

'Open %ExcelFileName% nil t

[ahankhah]

Code: [Select]

'Open %ExcelFileName% nil t

Thank you VovKa for your advise. Meanwhile I did "Try and Error" and found same result. The code can be as following:

Code - Auto/Visual Lisp: [Select]

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

Again, I appreciate your help.

[d2010]

I do not why, the autodesk.forum.lisp, spam  all Topics with Lisp+Microsoft Excel.
If you sharing VLisp+Excel functions/ then you post Copyright-violations, you are enemy of Microsoft-Copyrights?!
If you sharing VLisp+Excel functions/ then you became Hacker.
 

Code: [Select]

'Open %ExcelFileName% nil t