Sharepoint DocumentLibraryVersion not working? (Sharepoint CSOM,VBA) RRS feed

  • Question

  • Hi,

    I am trying to extract the version history for an Excel document from our Sharepoint cloud repository.   

    The starting point should be a quick and dirty trial in VBA.  

    There is an example of how to do this sort of thing here

    However,  when I run the example it consistently hangs on this line:

    Set dlvVersions = ActiveDocument.DocumentLibraryVersions

    I have tried this in Excel, Visio and Word docs and the behaviour is the same.  

    [In each case making the ActiveDocument the correct type - Excel, Word, Visio]

    I have the Microsoft Office 16.0 Object Library  selected in the References dialog.

    Google indicates that others have had trouble with this too.

    I am just about to give up on this and look at using the Rest API and R instead, but I thought I would check on here before doing so.

    Thanks in advance!




    • Edited by Reynolds531 Monday, January 6, 2020 12:43 PM removed carriage returns
    Monday, January 6, 2020 12:42 PM