Out of curiosity, why not use a Marketplace App? Jira Cloud for Excel (official) is built by Atlassian and free. And there are dozens of others offering all kinds of bells and whistles.
That said, the REST API should work from VBA. Can you indicate what URL you are trying to reach?