+ Reply to Thread
Results 1 to 2 of 2

Retrieve SharePoint Document Library weburl path P1

  1. #1
    Registered User
    Join Date
    07-12-2018
    Location
    Houston, Texas
    MS-Off Ver
    2016
    Posts
    44

    Retrieve SharePoint Document Library weburl path P1

    Good morning, All.

    I have a large project solution to retrieve files from a SharePoint document library to open and save a particular worksheet. This main solution architect is to have this master file saved on multiple SharePoint sites for team collaboration. Part one of this solution is to be able to retrieve the Master file's saved urlpath.

    For example,

    Site1: https://demo.sharepoint.com/sites/Demo1/Shared Documents/Channel1/Master.xlsm
    Site2: https://demo.sharepoint.com/sites/Demo2/Shared Documents/Channel1/Master.xlsm

    Once I open the file in either location, it should be able to harvest the entire site urlpath.

    Is that even possible?

  2. #2
    Registered User
    Join Date
    07-12-2018
    Location
    Houston, Texas
    MS-Off Ver
    2016
    Posts
    44

    Re: Retrieve SharePoint Document Library weburl path P1

    For anyone crawling, the solution is quite.... easy.

    Please Login or Register  to view this content.
    The above code does the trick. It will retrieve my SharePoint weburl of the path.

+ 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-05-2015, 10:45 PM
  2. Sharepoint Excel Document Library Setup
    By Blackbird_71 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-05-2015, 01:14 PM
  3. Excel rollup macro works on file share but not in SharePoint document library
    By mscurtin67 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2013, 01:46 AM
  4. Excel Document Library:When I customize the filename, I lose the path to the server
    By L01$Lan3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2011, 08:38 AM
  5. Expose cell values to SharePoint document library
    By phaley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2008, 12:23 PM
  6. Ho do I upload an Excel WorkBook to a SharePoint Document Library using VBA
    By mirror1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2008, 11:24 PM
  7. Replies: 0
    Last Post: 05-07-2006, 10:45 PM

Tags for this Thread

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