Edit Excel in Azure Blob Storage and run macros in it.

Question

Hi All,

So I have this requirement in which I have an excel file with macros in it. I want to run the macros that fetches data from Odata source and process the file to synapse.

Currently I am using PowerShell to run the macros on my local system, save it and upload it as blob and finally trigger the pipeline that loads data into synapse. I have installed Az Module to accomplish all the above steps.

But I want to run the macros directly in Azure by reading the excel from Blob storage and use only Azure services. I don't want to keep my files in my local. All the steps mentioned above I want to do in Azure. So for this I created Azure Automation account in which I can run the pipeline but how can I run macros?

Please let me know if there is a way to do this.

Thanks

Answer 1

@Ashish Sinha
Apologies for the delay responding here and an inconvenience it has caused. Unfortunately there is not currently a way to execute an Excel macro from Azure. There is a similar thread over on StackOverflow which might have some helpful suggestions. They have opened a feedback item for this as well. Feel free to upvote this item and add your specific use-case information. These feedback items are monitored by the product teams.

Hope this helps. Let us know if you have further questions or issues and we will do our best to assist.

-------------------------------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.