How to have excel macros working under Azure Active Directory Authentication in a normal .NET Web Application Project?

Question

We have a .NET Web Application running on latest technology stack wherein it uses SQL Server in the back-end and MS Blazor in the front-end. Also some portion of front-end exist in excel since we are using some macros to accomplish functionalities like filling up the grid cells of excel sheet using the JSON returned from the Web API call. The Web API call has been implemented using Azure AD integrated authentication. Now we wish the macros to also use Azure AD Authentication.

Please help us with some pointers or some concept related help or reference to other portal altogether or a better idea to accomplish the whole thing in the better new way.

Thanks and Regards

Answer 1

Hi @Anonymous ,

Thank you for your patience throughout this issue.

I checked this internally and to authenticate the macros with Azure AD you can either digitally sign the macros or do certification-based authentication with Azure AD and Azure Key Vault.

Digital signatures can be used to ensure that the macros are from a trusted source, and no one tampered with the data.

Certification-based authentication involves obtaining a certificate from Azure Key Vault, which can then be used to authenticate the user and the macros. This approach provides strong security and can be used where the macros need to access sensitive data.

Hope this will help.

Thanks,

Shweta

Please remember to "Accept Answer" if answer helped you.