I have a workbook that creates a number of PDF files that are synced to my OneDrive.
The same workbook creates an email with links to those PDFs which can then be viewed by the email's recipients. This worked fine as I had hard coded the OneDrive share links into my code.
However, this has recently stopped working and it looks like each time I save the PDFs, which overwrite the Old PDFs of the same name, the share link no longer works!


I know the local path and filename, and this never changes, but in itself is no use to the recipients of the email. I would like to be able to dynamically create the OneDrive share links following the export to PDF.
Any ideas?

My issue with links not working is connected to my Firefox browser! If I get Outlook to open the PDFs using Edge or Chrome everything is tickety-boo. I don't yet know what has caused this to suddenly occur but it is not an issue for this forum.


However, I would still like to know if I can create the share link from within the vba that has just created the PDF.