Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
103
Views
Topic starter
Hello,
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,
Claude
Posted : 18/10/2018 10:15 am
Hi Claude,
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
https://docs.microsoft.com/en-us/onedrive/developer/rest-api/?view=odsp-graph-online
Regards
Phil
Posted : 19/10/2018 11:57 pm
