How can I lock the file while editing by VBA?

S’abonner

Nouvelle publication

Marek1

• 13 avril 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

  • 14 avril 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

  Actions pour les commentaires Permalien
• 

  Marek1

  • 18 avril 2017 23:40

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

  0

  Actions pour les commentaires Permalien
• 

  badribax

  • 30 juillet 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

  Actions pour les commentaires Permalien
• 

  Nayak

  • 11 août 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

  Actions pour les commentaires Permalien

Vous devez vous connecter pour laisser un commentaire.