Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
628
Views
Topic starter
Scenario : A Workbook (eg Data.xlsx) exists in the Cloud (OneDrive) and access is required to read that Workbook via VBA
The problem : Using the VBA Workbook VBA statement Workbooks.Open(< Workbook location >) what is the syntax for <Workbook location>
For a local folder the syntax would be eg Workbooks.Open("C:FolderData.xlsx) -
In the case of Cloud access what is the replacement for C:
Posted : 30/05/2022 7:57 pm
Hi Kevin,
try:
Workbooks.Open Filename:="https://1drv.ms/your_link_to_file"
Posted : 04/06/2022 5:47 am
Topic starter
Thanks for your reply Catalin
The syntax you suggested seems OK - I just have to resolve my Credentials problem to execute
Posted : 05/06/2022 8:54 pm
