none
Get Excel Document Location when using Sharepoint folder synced to computer RRS feed

  • Question

  • I have an excel file and want to get the documents 'Location' as showing in the Document Properties Panel (i.e. folder directory and filename). 

    My file is stored in SharePoint, and when opened through SharePoint I can use ActiveWorkbook.FullName to get the URL string that I want.

    However, when I sync the sharepoint folder and open the file through the synced folder I get the local address (ie. C:\..., rather than https://).  I understand why, but the https URL shows up in the Document Properties Panel in the Locations field and I would ideally like to get that https address, rather than the local address, but I have no idea how to do so. I hope that made sense, if so, can anyone tell me how in Excel I can get the https address for a workbook opened from a synced sharepoint folder? 

    Thanks,

     
    Thursday, October 16, 2014 6:53 PM

All replies

  • Hi James,

    Thanks for posting in MSDN forum.

    >> when I sync the sharepoint folder and open the file through the synced folder I get the local address (ie. C:\..., rather than https://).  I understand why, but the https URL shows up in the Document Properties Panel in the Locations field and I would ideally like to get that https address, rather than the local address, but I have no idea how to do so.<<

    Did you mean when you open file in local folder then the full name returns local address and if it was opened in web, then the full name returns with https?

    If I understand correctly, the behavior is correct in my optionion. If I misunderstood, please feel free to let me know.

    Best regards

    Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, October 21, 2014 2:18 AM
    Moderator