Bastringue
12-22-2023, 05:52 AM
Hello,
I am afraid this question looks classical but I cannot find any good response...
I have a 2-file Excel application : a Front-end and a Back-end (data)
I have put the backend on OneDrive and would like to connect the Front-end to it.
I have the "OneDrive" link wich reads like this: https://onedrive.live.com/edit?id=D0BC45.........nVlJmF0PTk&migratedtospo=true&wdo=2
I have tried something like this in my VBA code:
Workbooks.Open(Filename:=lienPartage).Activate
But it just fails when trying to open the file...
Yet, the OneDrive link itself is OK as when I put it in my browser, it opens it.
Would you know how to connect my Front-end Excel to the Back-end, and to open it (with read/write access) ?
Thanks anyhow for your advice,
Pierre
I am afraid this question looks classical but I cannot find any good response...
I have a 2-file Excel application : a Front-end and a Back-end (data)
I have put the backend on OneDrive and would like to connect the Front-end to it.
I have the "OneDrive" link wich reads like this: https://onedrive.live.com/edit?id=D0BC45.........nVlJmF0PTk&migratedtospo=true&wdo=2
I have tried something like this in my VBA code:
Workbooks.Open(Filename:=lienPartage).Activate
But it just fails when trying to open the file...
Yet, the OneDrive link itself is OK as when I put it in my browser, it opens it.
Would you know how to connect my Front-end Excel to the Back-end, and to open it (with read/write access) ?
Thanks anyhow for your advice,
Pierre