Jump to content
Ahankhah

Open Excel Document as ReadOnly

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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. 👆

Share this post


Link to post
Share on other sites
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

  • Like 1

Share this post


Link to post
Share on other sites
Ahankhah
Posted (edited)
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 by Ahankhah

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...