1

I am new to SharePoint. I have an Excel workbook that has a macro that opens a power point slide. When the slide that it wants to open resides in a Windows directory (C:\ etc) everything works fine, I just specify the full path and file name. I recently moved the power point slide to SharePoint and I can't for the life of me figure out how to find the path to the slide.

Full disclosure, this is the second time I have moved a power point slide to SharePoint for similar opening by an Excel macro. Somehow I found the path the first time and the macro works fine, but I have no idea how I did it.

2

SharePoint files can be access via a web URL. So to find that URL you can open the browser, then type the SharePoint site url. Then choose the library/folder you uploaded the file.

Then you can right click the file and copy the URL. You can validate the URL by putting the URL in a new tab, which will open the file.

Another option is to open the library which has the file in Explorer (You can use Library tab from the ribbon and click on open in explorer button). Then copy the file path.

  • Thank You Amal. That worked. I was trying to copy he URL from the address bar (Like I do in windows). For some reason that didnt work. Oddly once your method worked I retried to copy it from the adress bar and that also worked. Not sure what I was doing yesterday ... – user40658 Mar 19 '15 at 13:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.