Good Afternoon,
what I thought would be a simple project is now driving me bonkers. I am trying to access an excel workbook saved on Onedrive to update it and then save and close.
I have the following line which does not error out but opens a random blank document
The following is what I hoped would open the actual document [lgc is shortened from the actual]
would be extremely grateful if anyone can point out what I am doing wrong or if you can actually open a onedrive document using VBA
Thanks in advance A
what I thought would be a simple project is now driving me bonkers. I am trying to access an excel workbook saved on Onedrive to update it and then save and close.
I have the following line which does not error out but opens a random blank document
Code:
Set wkbCashfile = Workbooks.Open(Filename:="https://lgc.sharepoint.com/:x:/s/Lgc/EWg9crnehMFOurAbM9GZt4wB2BanAQE_vg-aWfcBA_gVFQ?e=dLq1SA")
The following is what I hoped would open the actual document [lgc is shortened from the actual]
Code:
Set wkbCashfile = Workbooks.Open(Filename:="https://lgc.sharepoint.com/Lgc/Documents/Lgc_Cash_Account_Records.xlsm")
would be extremely grateful if anyone can point out what I am doing wrong or if you can actually open a onedrive document using VBA
Thanks in advance A