Microsoft

I am currently trying to make a macro that calls upon an excel file shared with me through OneDrive. The issue I'm running into is that the macro cannot call upon the file unless I download the file onto a local drive defeating the whole purpose of the macro to begin with. It is to my understanding I can make the macro download a copy, do what it needs and delete the copy afterwards, with an access token. Where do I go to get an access token for excel and OneDrive?

TLDR: How do I get an access token to use in an excel macro?