Checkout/in Excel Workbooks from SharePoint with VBA

I have found several articles and past questions in SO that help with this, but I have added a twist. I found a way to map a network drive on my PC to the SharePoint folders. If I open a workbook that is currently checked out I get the popup to choose read-only/notify/cancel. But if the workbook is not currently checked out, there is nothing that allows me to check it out (when I open it through the drive mapping) to prevent others from making changes. Is there a way to do this with VBA?

Super User Asked by Iron Man on November 27, 2021

1 Answers

One Answer

You should be able to check it with CanCheckOut method

If Workbooks.CanCheckOut(Filename) Then Workbooks.CheckOut (Filename)

KB CanCheckOut

KB CheckOut

Answered by Raystafarian on November 27, 2021

Add your own answers!

Related Questions

Nvidia Docker VNC with OpenGl and virtual display

0  Asked on January 6, 2021 by johni07


Remove the backstage Office 2016 / O365 for business

1  Asked on January 5, 2021 by yetanotherrandomuser


Automatic sleep vs Manual sleep

0  Asked on January 4, 2021


priority of the Linux group & user

1  Asked on January 3, 2021 by jw__fu


Delete a corrupt file in Linux

8  Asked on January 3, 2021 by stig


How to change brightness in FreeBSD?

1  Asked on January 1, 2021 by pouriya


Ask a Question

Get help from others!

© 2022 All rights reserved.