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?