Checking in a Document in SharePoint from Excel Macros

[tsaravana]

Hi,

We have mapped a network drive to a SharePoint Directory, while we are able to copy a file (using Macros) to this location, this file does not appear in SharePoint to the other users, the reason being that it is not checked in.
Can you help/guide us on how to Check using Excel Macros.

Let me know if you require any further details.

regards,
Saravanan

 

[Capt.Ragnar]

Here is some vba I used and manipulated for checking in or checking our documents on sharepoint with vba. I built the code from this and changed the check ins/outs based on what i needed the code to do.

Sub UseCanCheckOut()


Dim xlApp As Excel.Application
Dim wb As Workbook
Dim xlFile As String
xlFile = "http://test:8080/PWA/Project Documents/00 MS Excel
File/
BookTest.xls"


'Determine if workbook can be checked out.
If Workbooks.CanCheckOut(xlFile) = True Then
Workbooks.CheckOut xlFile


Set xlApp = New Excel.Application
xlApp.Visible = True


Set wb = xlApp.Workbooks.Open(xlFile, , False)


MsgBox wb.Name & " is checked out to you."


Else
' MsgBox "You are unable to check out this document at this
time."
End If


End Sub

 

[tsaravana]

Thanks Capt. will check this out.

regards,
Saravanan