Use Excel to obtain custom SP lists in POL... RRS feed

  • Question

  • Hi

    In this case I've got some custom fields in my Risks folder that I need to retrieve in Excel.  I can write a macro to create an odata script per project and extract that way but it's slow.

    Paul Mather has an excellent article on this using JS  (projSiteUrl + "/_api/Web/Lists/getByTitle('ProjectNotes')/Items").  However my JS skills aren't great but I know a little Excel VBA.  Is there anyway I can use VBA to bring the list into Excel or maybe another way.

    Many thanks 


    Andrew Binnz

    Monday, October 3, 2016 11:12 AM