Onedrive VBA getting share link of a file
<p>my question is rather simple but I've spent several hours googling trying to find a straight forward solution but I haven't found it.</p>

<p>Basically, using vba I want to save an Excel file to oneDrive's public folder which automatically will upload the file to the cloud, and I want to get a share link to that file so I can include it in an automatically generated email. I can already generate the automated email using vba and saving the file to the onedrive folder wouldn't be a problem I think but I want to include the share link before sending the email</p>

<p>I've read a little bit about rest and I have found info on how to communicate with one drive using a number of different programming languages but I haven't found any example vba interacting with onedrive.</p>

<p>Any help will be greatly appreciated</p>