PowerAutomate online excel refresh

[awsiya]

I have a power automate flow and one step is where it needs to refresh a VBA excel that is located in SharePoint.  But I feel it is not allowing to share excel online. What is a work around..i tried powerautomate desktop. That is bit complicated. Please let me know what is better way to sort this issue. 

[v-saisrao-msft · Accepted solution]

Hi @awsiya,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-saisrao-msft]

Hi @awsiya,

It seems you are facing challenges refreshing a VBA-enabled Excel file in SharePoint using Power Automate. We recommend posting your query in the Power Automate forum to get potential solution.
Microsoft Power Platform Community Forum Thread

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.     

Thank you.

[Omid_Motamedise]

What is your VBA code?
can you handle it by Power Query?

[Akash_Varuna]

Hi @awsiya , Is the VBA convertable to Power Query Or office scripts try with that approach as Power Automate Desktop is complicated