I have an excel file that sits in a shared drive (MS One drive) and I would like to run an R script that updates some data in that file. Is there a control in R to force close any open instances of that file so that the data update runs ok?
I have tried the close() and file() functions but without success.
Any ideas?
Thank you