To fix this issue There are two different permissions: one is application permission, the other is delegated permission. "Delegated" permissions, which specify scope-based access using delegated authorization from the signed-in resource owner, are presented to the resource at run-time as "scp" claims in the client's access token.
hope this fix your issue Right now the MSA Authentication only supports Desktop and Windows Mobile Apps as it needs UI to require user sign in which broke in your case because you have a console app. So the problem is to build a IAuthenticationProvider which set the Authorization header in request message like:
public async Task AuthenticateRequestAsync(HttpRequestMessage request)
request.Headers.Authorization = new AuthenticationHeaderValue("bearer", await GetAccessTokenFromSomeWhere());
ADAL4J in java application not working for native application(Azure Active Directory) when Multi Factor Authentication i
To fix this issue I think you are going to really struggle to achieve this from VBA. You would need to use a XmlHttpRequest library to make the HTTP calls to do the OAuth2 login flow. That's not going to be easy. What you might be easier is to create a VB.NET or C# application that calls OneDrive and then using an ODBC/OLEDB provider to write to the Access file. It just depends what you are trying to do whether this would be a suitable approach.