Excel and Sharepoint macro to list external links and the status of the sharepoint file
I have a huge sharepoint library with ~ 50 users. I then have a consolidated spreadsheet that links to these file (I agree it should be in a database but it is not). I want to create a sheet that lists all the external links and then displays the properties of the sharepoint file (i.e. checked out to, last modified date, last modified by).
I found this code that works well for creating a listing of all the external links but that is as far as I can go. I have searched and searched but not much info on VBA in sharepoint.
Dim aLinks As Variant
aLinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(aLinks) Then
For i = 1 To UBound(aLinks)
Cells(i, 1).Value = aLinks(i)
This code will list all the files in format https://.....
I also have mapped the sharepoint directory to my network if that helps.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By kopite2002 in forum Excel Programming / VBA / Macros
Last Post: 10-22-2013, 01:56 AM
By Flipp in forum Access Tables & Databases
Last Post: 01-17-2013, 04:37 AM
By koltregaskes in forum Excel Programming / VBA / Macros
Last Post: 11-19-2011, 04:15 PM
By DKY in forum Excel Programming / VBA / Macros
Last Post: 04-15-2010, 06:41 AM
By gtg653t in forum Excel Programming / VBA / Macros
Last Post: 07-10-2008, 10:43 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1