October 17, 2018
Can I open an online Onedrive file in a macro ? The file is owned by my client and updated on a daily basis, I would like to open the file in VBA using the URL, is it possible ? Note that I have my client's Onedrive username and password ?
Thanks for your help,
October 5, 2010
So you want to open a file in Excel desktop from OneDrive, using VBA to open it? I'm not aware of a way to do this.
But you could do it using the Live SDK REST API
or the newer OneDrive API