How can I lock the file while editing by VBA?

Follow

New post

Marek1

• April 13, 2017 03:01

Hi all,

 

I us the boxSync file to run the macros but I want to lock the file by macro so other user can not run the macro or update the file at the same moment. Is there any function to automaticaly lock the file when it is opened by user and unclock when closing the file?

 

Thank you!

0

• 

  Murtza

  • April 14, 2017 15:14

  This endpoint lets you lock and unlock a file, but I am not sure how to make this API call using VBA.

  0

  Comment actions Permalink
• 

  Marek1

  • April 18, 2017 23:40

  Thank you Murtza! I will take a look on that whether I can use it or not.

  0

  Comment actions Permalink
• 

  badribax

  • July 30, 2020 08:37

  Hello,

   The link "this endpoint" takes to the page which has the list of APIs, can you please let me know which is the exact API that can be used to lock/unlock a file.

   

  Thanks,

  0

  Comment actions Permalink
• 

  Nayak

  • August 11, 2020 01:39

  Hi , the link is not valid now since the developer website got updated. You need to make a Update call on the file with lock parameter, hope this helps.

  0

  Comment actions Permalink

Please sign in to leave a comment.