+ Reply to Thread
Results 1 to 3 of 3

VBA to Download SharePoint List to Excel

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    35

    VBA to Download SharePoint List to Excel

    Wondered if anyone has tried this before. Embarrasingly I have managed to do this years ago but now can't find a copy of how I did it !! Also was a much older version of SharePoint so maybe not the same now.

    I am wanting to use VBA to download a View from a SharePoint list and populate an area on a Worksheet that already exists.

    I have Googled but sadly the few examples I have found aren't working.

    Access to the SharePoint site is via https.

    Format to URL for the list is below (with soem xxx'sinstead of main name.

    https://xxxx.sharepoint.com/sites/In.../AllItems.aspx

    Many thanks
    Mike

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA to Download SharePoint List to Excel

    Mike,

    the format is irrelevant. that's just a source. are you sure you looked up everything? looks like stuff here:

    https://www.google.com/search?q=vba+...harepoint+list

    stack ex:

    https://sharepoint.stackexchange.com...using-vba-only

    and considering it's definition:

    https://en.wikipedia.org/wiki/SharePoint

    it should be very easy to hook it into excel because worksheets, views and lists are essentially the same thing over and over again anyway.

  3. #3
    Registered User
    Join Date
    10-29-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: VBA to Download SharePoint List to Excel

    Thanks for the links. Will have a look at those and let you know how I get on

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-28-2020, 02:32 PM
  2. How to Download File from Password Protected SharePoint using VBA (CAC Login)?
    By ChrisHook in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2019, 05:46 PM
  3. VBA Code to Download Files from sharepoint to Local Network drive
    By xlsvba87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2015, 03:35 PM
  4. Download file from SharePoint using mac excel 2011 VBA
    By rafik2k10 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-22-2014, 03:07 AM
  5. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  6. Replies: 0
    Last Post: 08-15-2013, 12:11 PM
  7. Sharepoint List + Excel
    By vikasbhandari in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2008, 08:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1