Use VBA to open a document from OneDrive and then edit it

I want my excel spreadsheet to be able to open a file that is saved on OneDrive, then add some information to the next available line, save and close. I think I could figure it out if I got help with opening the file that is saved on OneDrive. Does anyone know how to do that part?