How to authenticate and use REST APIs from Excel VBA Macro?

Summary

Trying to use Excel VBA to authenticate and get documents using REST APIs

Content

Hi All,

I host some XLS files in my OCE and my business requirement is to access these ones from Excel VBA Macro (Excel document requires some data stored in XLS files).

I am trying to authenticate based on the link below:

https://docs.oracle.com/en/cloud/paas/content-cloud/developer/try-apis-using-oauth.html

but it is not so clear for me to build this solution using VBA.

Previously, I hosted the files on Beehive and just using these key line codes:

accessFile = "https://stbeehive.oracle.com/content/dav/st/{Workspace_name}/Documents/Others/****.xls&quot