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?