Automate Excel with Office Scripts and Power Automate
HTML-код
- Опубликовано: 7 фев 2023
- Office Scripts can be created with a few clicks to help with repetitive actions in Excel. Add Power Automate into the mix and you can automate almost anything in Excel.
Learn More: aka.ms/globalexcelsummit/offi... Наука
This is exactly what I needed. I'll be implementing it tomorrow. Thanks.
Awesome!
@@AprilDunnam with version of office have the Automate tab?
Super awesome.
Thank you! Cheers!
Does this only work for the lines that the recording predetermined? Or is it able to sense if there are hundreds of entries in Column B and C and add the formula in as far down as the data goes?
Is this automate option available in office 2019?
Wonderful 👍
Thank you! Cheers!
What if you have one excel sheet that you want to use for lookups, based on another file in power automate ?
You can write a function in your script
use 'Run the script through Power Automate' to add your input, which maybe your result from another excel file.
You’ve been to do this with VBA for decades
Ah, VBA, the timeless classic.... It's like the grandpa of low code programming languages