I am creating 300+ Excel workbooks in code and saving them on SkyDrive. As I do so I want to be able to capture the share link using VBA and store it somewhere for later use but I cant see how to access the URL.
Any hints appreciated.
many thanks
rod