Hi. I'm new here. I'd appreciate some help with OAuth from someone more experienced with it.
I'm developing an Excel VBA app that will fetch data from a Hubspot account into a spreadsheet. It's just a small thing for use within one company.
I've got the authorization working, but it's a bit hacky. Since my app is not a web app, it's not convenient to have a dedicated web address for the redirect. At the moment, during development, I'm just using "https://www.example.com/" as the redirect URI, and then asking the user to copy/paste the authorization code from their browser address bar into an Excel dialog box. I'd like to know if there's any better way of doing it.
I believe there may be a way of getting the URL back from Internet Explorer (though I haven't looked into it). But I don't want to rely on my users having IE available.
Any ideas would be welcome.