updating a separate workbook via VBA?

[AceFI]

hi all.

i'm trying to work with live data updates on onedrive.. but can't seem to get things to work seamlessly, so i'm toying with the following;

Sub TESTOPEN()
Application.ScreenUpdating = False
Dim wb As Workbook, sh As Worksheet
Set wb = Workbooks.Open("MYFILE")
wb.RefreshAll
wb.Save
'wb.Close
Application.ScreenUpdating = True
End Sub

it seems to work, however its not 'saving' correctly... if i open the destination file in excel, it is updated.. if i open it online through a onedrive link it isn't updated... then if i manually open and save, it then updates..

any ideas?

thanks,