Excel VBA API token authentication

[Phil_Seeman]

Use my line of code instead. You want “Bearer”, not “Basic”, and you don’t need to Base64 Encode your PAT.

EDIT:
Oh well if you’re saying your code worked, then you can certainly use that! But it does more than you need.