When I issue these 2 commands back-to-back, the checkout command seems to not wait long enough for the opening file to be fully opened and I get an error message on the checkout command Runtime 1004: The document cannot be checked out. The weird thing is that the CanCheckOut command says it can be checked out. However, if I wait a bit and re-execute the checkout command it works. How can I have the system wait the correct amount of time for SharePoint to be ready to allow checkout? If I put a wait 2 seconds command in there it works fine, but that may be too long sometimes and not long enough other times. How can I allow "just the right amount of time"
Code:
If Workbooks.CanCheckOut(FileName:=docCheckOut) = True Then
Workbooks.Open FileName:=docCheckOut, UpdateLinks:=False
Workbooks.CheckOut docCheckOut
End if
Last edited:
