Answered

Excel files on teams

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, Good afternoon. I have excel files saved on teams. Can I use VBA / Powerautomate to open as well as manipulate the data that is in these excel files? Thank you for your time!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Something for you to explore is office scripts. You can build a typescript function and call this as an action from PowerAutomate.

some examples here https://techcommunity.microsoft.com/t5/microsoft-365-pnp-blog/excel-scripts-and-cloud-flows-data-manipulation/ba-p/2356956

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you DamoBird365

Was this reply helpful? Yes No