Save to OneDrive shared folder

[adambc]

This is linked to a previous post of mine Select Slicer Selections in turn

My print to a PDF file saves the PDF files in a named folder which I get to by using its pathname ie C:\User\OneDrive\Documents/etc/etc ...

I now want to save the PDF files to a OneDrive folder someone has shared with me, but using the URL as the pathname doesn’t work - does anyone here know how I can either still use the URL, or how I can obtain a “real” pathname that i can use?

Thanks ...

 

[adambc]

OK, no takers, so let's see if further explanation helps?

I have a Excel VBA Macro that loops through a Slicer, each time creating a print to PDF file (of the filtered Worksheet) ...

On my local machine, I construct the path/file names as follows ...

Set wsA = ActiveSheet

strTime = Format(Now(), "yyyymmdd\_hhmmss")
strPath = "C:\Users\User\OneDrive\Documents\Personal\Adam\Work\PDF_Files" '<<< REPLACE WITH PATHNAME FOR A ONEDRIVE SHARED FOLDER
strPath = strPath & "\"
strName = Replace(wsA.Name, " ", "")
strName = Replace(strName, ".", "_")
strFile = strName & "_" & Filename & "_" & strTime & ".pdf" '"Filename" is a variable set earlier in the code
strPathFile = strPath & strFile

... but I need to replace the local pathname with the pathname for a OneDrive Shared folder ie NOT the local sync folder ...

I have the URL for said Shared folder, but that doesn't work and no matter what I try (after searching online for hours!) nothing seems to work - HELP!!!

Thanks ...